Answer :
(a) Production Budget
| First quarter | Second Quarter | Third Quarter | Fourth Quarter | Total | |
| Budgeted sales units | 30000 | 40000 | 22500 | 27500 | 120000 |
| Add - Desired Closing inventory |
8000 (40000*20%) |
4500 (22500*20%) |
5500 ( 27500*20%) |
6900 (34500*20%) |
6900 |
| Total Required unit | 38000 | 44500 | 28000 | 34400 | 126900 |
| Less - Opening inventory | 6000 | 8000 | 4500 | 5500 | 6000 |
| Units to be produced | 32000 | 36500 | 23500 | 28900 | 120900 |
(b) Computation of Budgeted unit production in 3rd Quarter
| Third Quarter | |
| Budgeted sales units | 22500 |
| Add - Desired Closing inventory |
4043 (Approx ) ( 27500*14.70%) |
| Total Required unit | 26543 |
| Less - Opening inventory | 3308 (Approx) |
| Units to be produced in third Quarter | 23235 |
What if Clapton Company in Example 9-1 changed their desired ending inventory level to equal 14.7%...
What if Clapton Company in Example 9-1 changed their desired ending inventory level to equal 20.5% of next quarter's budgeted sales instead of 20%. How many budgeted units would be produced in the 3rd quarter (July- September)? Round your answer to the nearest whole unit. Clapton Company's sales budget shows the following projections for the year ending December 31, 2017: Quarters First (Jan - March) Second (April - June) Third (July - Sept) Fourth (Oct - Dec) Total Guitars 30,000...
On December 31, 2017, Waterway had 30 acoustic guitars in stock-fewer than the desired inventory level of 84 guitars, based on the following quarter's sales. The company has budgeted for sales of 240 acoustic guitars in the first quarter of 2019. Prepare the 2018 production budget for acoustic guitars. Production Budget 2nd Quarter 3rd Quarter 1st Quarter 4th Quarter Annual Waterway Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional...
Hectro Company manufactures an Innovative automobile transmission for electric cars. Management predicts that ending finished goods Inventory for the first quarter will be 50,000 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 500,000 units, third quarter, 454,000 units, and fourth quarter, 366,500 units. Company policy calls for the ending finished goods Inventory of a quarter to equal 10% of the next quarter's budgeted sales. Prepare a production budget for both...
Electro Company manufactures an innovative automobile
transmission for electric cars. Management predicts that ending
finished goods inventory for the first quarter will be 277,800
units. The following unit sales of the transmissions are expected
during the rest of the year: second quarter, 463,000 units; third
quarter, 317,000 units; and fourth quarter, 499,000 units. Company
policy calls for the ending finished goods inventory of a quarter
to equal 60% of the next quarter's budgeted sales.
Prepare a production budget for both...
Coronado Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Vanessa Aaron, the company's sales manager, prepared the following sales forecast for 2018. The forecasted sales prices include a 5% increase in the acoustic guitar price and a 10% increase in the electric guitar price, to cover anticipated increases in raw materials prices. 3rd Quarter 4th Quarter Sales Price $1.200 $2,370 1st Quarter 210 420 2nd Quarter 300 Acoustic...
Exercise 23-6 (Part Level Submission) On January 1, 2017, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: Ending raw materials inventory: Ending finished goods inventory: Third-quarter production: First quarter 5,600; second quarter 6,300; third quarter 7,000 40% of the next quarter's production requirements 25% of the next quarter's expected sales units 7,820 units The ending raw maferials and finished goods inventories at December 31, 2016, follow...
SarasotaCompany is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,200,000 units. Quarterly sales are 18%, 25%, 23%, and 34%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than...
Benet Company has budgeted the following unit sales: 2017 2016 Quarter Units Quarter Units 1 105,000 1 90,000 2 60,000 3 75,000 4 120,000 The finished goods inventory on hand on December 31, 2015 was 21,000 units. It is the company's policy to maintain a finished goods inventory at the end of each quarter equal to 20% of the next quarter's anticipated sales. Prepare a production budget for 2016.
Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 170.500 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 341,000 units; third quarter, 219,000 units, and fourth quarter, 266,000 units. Company policy calls for the ending finished goods inventory of a quarter to equal 50% of the next quarter's budgeted sales. Prepare a production budget for both...
Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 83,400 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 417,000 units; third quarter, 476,000 units; and fourth quarter, 276,500 units. Company policy calls for the ending finished goods inventory of a quarter to equal 20% of the next quarter's budgeted sales. Prepare a production budget for both...