Question

A company makes and sells a seasonal products . based on a sales forecast of 2000,...

A company makes and sells a seasonal products . based on a sales forecast of 2000, 3000, and 5000 per quarter , calculate a level production plan , quarterly ending inventory , and average quarterly inventory . if inventory carrying cost are 3 $ per unit per quarter , what is the annual cost of carrying inventory ? opening and ending inventories are zero .

answer by a typing please

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. Calculation of Production Plan

Quarter 1 Quarter 2 Quarter 3 Quarter 4
Opening Inventory(given as zero) 0 0 0 0
Production 2000 3000 5000 0
Closing Inventory(given as zero) 0 0 0 0
Sales per quarter(Given) 2000 3000 5000 0

2. Quarterly Ending Inventory is 2000 3000 5000 0

3. Average Quarterly Inventory is (2000+3000+5000)/4 = 2500

4. Calculation of Annual Cost of Carrying Inventory   

Quarter 1 Quarter 2 Quarter 3 Quarter 4
Inventory during the quarter 2000 3000 5000 0
Inventory cost per unit per quarter(given) 3$ 3$ 3$ 3$
Cost (Sales x Inventory cost) $6000 $9000 $1500 0

Therefore Total annual cost of carrying inventory is $6000+$9000+$15000 = $30000

Add a comment
Know the answer?
Add Answer to:
A company makes and sells a seasonal products . based on a sales forecast of 2000,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A firm manufactures snow blowers. The demand for snow blowers follows a seasonal pattern with highs...

    A firm manufactures snow blowers. The demand for snow blowers follows a seasonal pattern with highs during the winter months and lows during the summer months. The firm’s cost data and sales forecasts are as given below. Quarter Sales Forecast (units) Spring 80,000 Summer 50,000 Fall 120,000 Winter 150,000 Hiring cost is $100 per worker Firing cost is $500 per worker Inventory carrying cost is $0.50 per unit per quarter Production per employee is 1,000 units per quarter Beginning work...

  • Togo makes riding lawn mowers and tractors. The company’s expected quarterly demand is given belo...

    Togo makes riding lawn mowers and tractors. The company’s expected quarterly demand is given below in the chart. The company will have 300 mowers in inventory at the beginning of the month and desires to maintain at least that number at the end of each month. Below is other critical data: Production cost per unit = $325 Inventory carrying cost per month per unit = $60 (based on ending month inventory) Hiring cost per worker = $450 Firing cost per...

  • Thurston Products sells a popular style of running shoe. The company has prepared the following sales...

    Thurston Products sells a popular style of running shoe. The company has prepared the following sales forecast for the second quarter of 2010: April         80 000 pairs May          100 000 pairs June   130 000 pairs Ending inventory at 31 March 2010 was budgeted at 5000 pairs. Management would like the desired quantity of finished goods inventory at the end of each month to be equal to 6 per cent of next month’s budgeted unit sales. July’s...

  • Culver Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as...

    Culver Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as follows. Quarter HD-240 1 5,400 2 7,430 3 8,450 4 10,230 The January 1, 2017, inventory of HD-240 is 2,160 units. Management desires an ending inventory each quarter equal to 40% of the next quarter’s sales. Sales in the first quarter of 2018 are expected to be 25% higher than sales in the same quarter in 2017. Prepare quarterly production budgets for each quarter...

  • Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as...

    Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as follows. Quarter NM + HD-240 5,200 7,150 8,320 10,190 The January 1, 2020, inventory of HD-240 is 2,080 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2021 are expected to be 25% higher than sales in the same quarter in 2020. Prepare quarterly production budgets for each quarter and in...

  • Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as...

    Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as follows. Quarter HD-240 5,100 7,490 8,330 10,350 The January 1, 2020, inventory of HD-240 is 2,040 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2021 are expected to be 25% higher than sales in the same quarter in 2020. Prepare quarterly production budgets for each quarter and in total for...

  • Thanks! Bridgeport Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is...

    Thanks! Bridgeport Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as follows. Quarter HD-240 5,200 2 7,110 8,190 10,240 The January 1, 2017, inventory of HD-240 is 2,080 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2018 are expected to be 25% higher than sales in the same quarter in 2017. Prepare quarterly production budgets for each quarter and in...

  • Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as...

    Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as follows. Quarter HD-240 1 5,200 2 7,420 3 8,110 4 10,150 The January 1, 2017, inventory of HD-240 is 2,080 units. Management desires an ending inventory each quarter equal to 40% of the next quarter’s sales. Sales in the first quarter of 2018 are expected to be 25% higher than sales in the same quarter in 2017. Prepare quarterly production budgets for each quarter...

  • Exercise 21-4 Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast...

    Exercise 21-4 Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as follows. Quarter HD-240 1 5,200 2 7,220 3 8,280 4 10,180 The January 1, 2017, inventory of HD-240 is 2,080 units. Management desires an ending inventory each quarter equal to 40% of the next quarter’s sales. Sales in the first quarter of 2018 are expected to be 25% higher than sales in the same quarter in 2017. Prepare quarterly production budgets for...

  • Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as follows....

    Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as follows. Quarter HD-240 1 5,400 2 7,430 3 8,450 4 10,230 The January 1, 2020, inventory of HD-240 is 2,160 units. Management desires an ending inventory each quarter equal to 40% of the next quarter’s sales. Sales in the first quarter of 2021 are expected to be 25% higher than sales in the same quarter in 2020. Prepare quarterly production budgets for each quarter...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT