Solution
1. Revenue budget:
Units | price | Total | |
12-oz bottles(450000×12) | 5,400,000 | $0.60 | $3,240,000 |
1-gallon containers(130000×12) | 1,560,000 | $1.40 | $2,184,000 |
Budgeted revenue | $5,424,000 |
2. Production budget:
12 oz bottles | |
Budgeted sales in units | 5,400,000 |
Add target ending finished goods inventory | 650,000 |
Total requirements | 6,050,000 |
Deduct beginning finished goods inventory | 950,000 |
Units to be produced | 5,100,000 |
3. The beginning inventory of 1gallon containers, in units is 160,000 on January 1,2018.
Explanation:
Production budget:
1 gallon containers | |
Budgeted sales in units | 1,560,000 |
Add target ending finished goods inventory(given) | 300,000 |
Total requirements | 1,860,000 |
Deduct beginning finished goods inventory(430000-170000) | 160,000 |
Units to be produced(given) | 1,700,000 |
Polite, Inc., bottles and distributes mineral water from the company's natural springs reusable plastic cont...
Potts, Inc., bottles and distributes mineral water from the company's natural springs in northern Oregon. Potts markets two products: 12-ounce disposable plastic bottles and 1-gallon reusable plastic containers. Read the requirements. Requirement 1. For 2018, Potts marketing managers project monthly sales of 480,000 12-ounce bottles and 120,000 1-gallon containers. Average selling prices are estimated at $0.80 per 12-ounce bottle and $1.30 per 1-gallon container. Prepare a revenues budget for Potts, Inc., for the year ending December 31, 2018. Revenues Budget...
Polin, Inc., bottles and distributes mineral water from the company's natural springs in northern Oregon. Polin markets two products: 12-ounce disposable plastic bottles and 1-gallon reusable plastic containers. Read the requirements Requirement 1. For 2018, Polin marketing managers project monthly sales of 410,000 12-ounce bottles and 130,000 1-gallon containers. Average selling prices are estimated at $0.40 per 12-ounce bottle and $1.90 per 1-gallon container. Prepare a revenues budget for Polin, Inc., for the year ending December 31, 2018 Revenues Budget...
Prime, Inc., bottles and distributes mineral water from the company's natural springs in northern Oregon. Prime markets two products: 12-ounce disposable plastic bottles and 1-gallon reusable plastic containers. 1. For 2018, Prime marketing managers project monthly sales of 420,000 12-ounce bottles and 170,000 1-gallon containers. Average selling prices are estimated at $0.90 per 12-ounce bottle and $1.25 per 1-gallon container. Prepare a revenues budget for Prime, Inc., for the year ending December 31, 2018. 2. Prime begins 2018 with 970,000...
Pompi, Inc, bottles and distributes mineral water from the company's natural springs in northern Oregon. Pompi markets two products: 12 ounce disposable plastic bottles and 1 gallon reusable plastic containers. 1. For 2018 pompi marketing managers project monthly sales of 430,000 12 ounce bottles and 170,000 1 gallon containers. Average selling prices are estimated at $0.30 per 12 ounce bottle and $1.60 per 1 gallon container. Prepare a revenues budget for Pompi, inc, for the year ending December 31, 2018....
provided Nove Budgeted 2020 Sales: Water bottles February 7,000 produce a cash budger for March January 8.000 8,000 April 10,000 Additional information for your budget preparation is as follows: a) Because of increased competition the average sales price per water bottle in 2020 is expected to drop to b) Wonderful Water bottles has a policy that each month's ending inventory of finished goods (water bottles) $15.00 per bottle should be 20% of the following month's sales in units. Ending inventory...
What if Clapton Company in Example 9-1 changed their desired ending inventory level to equal 14.7% 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. Example #1 PRODUCTION BUDGET 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 40,000 22,500 27,500...
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...
QS 7-12 Manufacturing: Production budget LO P1 Champ, Inc., predicts the following sales in units for the coming two months May June 200 Sales in units 280 Each month's ending inventory of finished units should be 60% of the next month's sales. The April 30 finished goods inventory is 120 units. Compute Champ's budgeted production (in units) for May CHAMP, INC. Production Budget For Month Ended May 31 Next month's budgeted sales (units) 280 Ratio of inventory to future sales...
Please Answer All Part B in Order. Better By the Numbers began operations on January 1, 2018. The ounce bottles of hand and body lotion called Radiant One. The lo bottle cases for $100 per case. There is a selling commission of V 1, 2018. The company produces eight- adiant One. The lotion is sold wholesale in 12- Is a selling commission of $20 per case. a factory overhead costs are as follows: January 2018 direct materials, direct labor and...
please answer all section of #6 and #7. below is the info. and problem. Quivers Inc. began operations on January 1 of the current year. The company produces eight-ounce bottles of jet wax called Ophelia Shine. The wax is sold wholesale in 12-bottle cases for $100 per case. There is a selling commission of $20 per case . The January direct materials , direct labor, and factory overhead costs are as follows: this is data given to answer 6 and...