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
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
A company makes and sells a seasonal products . based on a sales forecast of 2000,...
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 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 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 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 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 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 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 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 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. 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...