Prepare direct materials purchases budget for may

Reference no: EM131259880

Question 1 - Direct materials purchases budget

Coca-Cola Enterprises is the largest bottler of Coca-Cola in Western Europe. The company purchases Coke and Sprite concentrate from The Coca-Cola Company, dilutes and mixes the concentrate with carbonated water, and then fills the blended beverage into cans or plastic two-liter bottles. Assume that the estimated production for Coke and Sprite two-liter bottles at the Wakefield, UK, and bottling plant are as follows for the month of May:

Coke - 153,000 two-liter bottles

Sprite - 86,500 two-liter bottles

In addition, assume that the concentrate costs $75 per pound for both Coke and Sprite and is used at a rate of 0.15 pound per 100 liters of carbonated water in blending Coke and 0.10 pound per 100 liters of carbonated water in blending Sprite. Assume that two liters of carbonated water are used for each two-liter bottle of finished product. Assume further that two-liter bottles cost $0.08 per bottle and carbonated water costs $0.06 per liter.

Prepare direct materials purchases budget for May 2016, assuming inventories are ignored, because there are no changes between beginning and ending inventories for concentrate, bottles, and carbonated water.

Question 2 - Factory overhead cost budget

Sweet Tooth Candy Company budgeted the following costs for anticipated production for August 2016:

Advertising expenses	$232,000	Production supervisor wages	$135,000
Manufacturing supplies	14,000	Production control wages	32,000
Power and light	48,000	Executive officer salaries	310,000
Sales commissions	298,000	Materials management wages	39,000
Factory insurance	30,000	Factory depreciation	22,000

Prepare a factory overhead cost budget, separating variable and fixed costs. Assume that factory insurance and depreciation is the only fixed factory costs.

Question 3 - Cost of goods sold budget

Delaware Chemical Company uses oil to produce two types of plastic products, P1 and P2. Delaware budgeted 35,000 barrels of oil for purchase in June for $90 per barrel. Direct labor budgeted in the chemical process was $240,000 for June. Factory overhead was budgeted $400,000 during June. The inventories on June 1 were estimated to be:

Oil - $15,200

P1 - 8,300

P2 - 8,600

Work in process - 12,900

The desired inventories on June 30 were:

Oil - $16,100

P1 - 9,400

P2 - 7,900

Work in process - 13,500

Use the preceding information to prepare a cost of goods sold budget for June 2017.

Question 4 - Schedule of cash collections of accounts receivable

OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 30% pay their accounts in the month of sale, while the remaining 70% pay their accounts in the month following the month of sale. Projected sales for the next three months of 2016 are as follows:

October - $58,000

November - 65,000

December - 72,000

The Accounts Receivable balance on September 30, 2016, was $35,000. Prepare a schedule of cash collections from sales for October, November, and December.

Question 5 - Forecast sales volume and sales budget

For 2016, Raphael Frame Company prepared the sales budget that follows. At the end of December 2016, the following unit sales data were reported for the year:

	Unit Sales
	8" x 10" Frame	12" x 16" Frame
East	8,755	3,686
Central	6,510	3,090
West	12,348	5,616

Raphael Frame Company Sales Budget For the Year Ending December 31, 2016
Product and Area	Unit Sales Volume	Unit Selling Price	Total Sales
8" x 10" Frame:
East	8,500	$16	$136,000
Central	6,200	16	99,200
West	12,600	16	201,600
Total	27,300		$436,800
12" x 16" Frame:
East	3,800	$30	$114,000
Central	3,000	30	90,000
West	5,400	30	162,000
Total	12,200		$366,000
Total revenue from sales			$802,800

For the year ending December 31, 2017, unit sales are expected to follow the patterns established during the year ending December 31, 2016. The unit selling price for the 8" x 10" frame is expected to increase to $17 and the unit selling price for the 12" x 16" frame is expected to increase to $32, effective January 1, 2017.

Instructions

1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2016, over budget. Place your answers in a columnar table with the following format:

	Unit Sales, year Ended 2016		Increase (Decrease) Actual Over Budget
	Budget	Actual Sales	Amount	Percent
8" x 10" Frame:
East
Central
West
12" x 16" Frame:
East
Central
West

2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2017, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2017. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit.

3. Prepare a sales budget for the year ending December 31, 2017.

Reference no: EM131259880

Questions Cloud

Advantages and disadvantages of viewing leaders this way : Would you like to be led by a "coach" as these organizations define it? What would be some advantages and disadvantages of viewing leaders this way?

Describes benefits of developmentally appropriate practice : Defines and Describes Benefits of Developmentally Appropriate Practice. Comprehensively defines developmentally appropriate practice and thoroughly describes its benefits. Utilizes several resources in description.

How much did corp pay for the bonds : On January 10, 2017, B Corporation purchased 321 of the $1,000 face value, 9%, 10-year bonds of Walters Inc. The bonds mature on January 1, 2027, and pay interest annually beginning January 1, 2018. B corp purchased the bonds to yield 11%. How much d..

Why do you think retailing leader made this move to walmart : Evaluate her self-described "fanatic about retail detail." How would this and other details in the case fit into what you have learned in this chapter about what leaders really do?

Prepare direct materials purchases budget for may : Coca-Cola Enterprises is the largest bottler of Coca-Cola in Western Europe. Prepare direct materials purchases budget for May 2016, assuming inventories are ignored, because there are no changes between beginning and ending inventories for concent..

Develop an aggregate plan for the 6 month period : Develop an aggregate plan for the 6-month period. - Compute the cost of Cohen's plan of using overtime and Forrester.

Paper addressing the different ethical conflicts the ada : Write a 2-3 page, APA style paper addressing the different ethical conflicts the ADA might experience from serving his time in prison and on probation. Please include 2-3 references. Only one reference may be from an internet source (not Wikipedia..

Corporation record as the cost of the machine : A Corporation bought a new machine and agreed to pay for it in equal annual installments of $4,880 at the end of each of the next 10 years. Assuming that a prevailing interest rate of 8% applies to this contract, how much should A corporation record ..

Improvements for workers in the organization : What is the process that employees will use to unionize? How can collective bargaining deliver improvements for workers in the organization? What does a union have to consider regarding a state's right to work laws?

User Account

All Pages