Question

Problem 8-30 Integration of the Sales, Production, and Direct Materials Budgets [LO8-2, LO8-3, LO8-4] Milo Company...

Problem 8-30 Integration of the Sales, Production, and Direct Materials Budgets [LO8-2, LO8-3, LO8-4] Milo Company manufactures beach umbrellas.

The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation:

a. The Marketing Department has estimated sales as follows for the remainder of the year (in units):

July 38,000

October 28,000

August 86,000

September 55,000

November 14,500

December 15,000

The selling price of the beach umbrellas is $13 per unit.

b. All sales are on account. Based on past experience, sales are collected in the following pattern:

30% in the month of sale

65% in the month following sale

5% uncollectible

Sales for June totaled $455,000.

c. The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June.

d. Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of Gilden be equal to 50% of the following month’s production needs. The inventory of Gilden on hand at the beginning and end of the quarter will be:

June 30 90,400 feet

September 30 ? feet

e. Gilden costs $0.60 per foot. One-half of a month’s purchases of Gilden is paid for in the month of purchase; the remainder is paid for in the following month. The accounts payable on July 1 for purchases of Gilden during June will be $48,390.

Required:

1. Calculate the estimated sales, by month and in total, for the third quarter.

2. Calculate the expected cash collections, by month and in total, for the third quarter.

3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October.

4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter. 5. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter.

6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter.

Homework Answers

Answer #1
1 Milo Company
Estimated Sales
July August September 3rd Quarter
Budgeted sales units 38000 86000 55000 179000
Selling price per unit $ 13 13 13 13
Estimated sales $ 494000 1118000 715000 2327000
2 Expected Cash Collections
July August September 3rd Quarter
June sales 295750 295750
July sales 148200 321100 469300
August sales 335400 726700 1062100
September sales 214500 214500
Expected cash collections $ 443950 656500 941200 2041650
3 Estimated Production
July August September October November
Budgeted sales in units 38000 86000 55000 28000 14500
Desired ending FG inventory as percent of following month's sales (units) 15% 15% 15% 15%
Ending FG inventory (units) 12900 8250 4200 2175
Required production (units) 50900 94250 59200 30175
Less: Beginning FG inventory (units) 5700 12900 8250 4200
Estimated production (units) 45200 81350 50950 25975
4 Gilden Purchases
July August September 3rd Quarter
Estimated production (units) 45200 81350 50950 177500
Gilden required per unit (feet) 4 4 4 4
Gilden required for production (feet) 180800 325400 203800 710000
Desired ending inventory of Gilden as percent of following month's production needs 50% 50% 50%
Ending inventory of Gilden (feet) 162700 101900 51950 51950
Total Gilden required (feet) 343500 427300 255750 761950
Less: Beginning inventory of Gilden (feet) 90400 162700 101900 90400
Quantity of Gilden to be purchased (feet) 253100 264600 153850 671550
5 Cost of Raw Material (Gilden) Purchases
July August September 3rd Quarter
Quantity of Gilden to be purchased (feet) 253100 264600 153850 671550
Raw material (Gilden) cost per foot $ 0.60 0.60 0.60 0.60
Cost of raw material (Gilden) purchases $ 151860 158760 92310 402930
6 Expected Cash Disbursements for Raw Material (Gilden) Purchases
July August September 3rd Quarter
June purchases 48390 48390
July purchases 75930 75930 151860
August purchases 79380 79380 158760
September purchases 46155 46155
Expected cash disbursements $ 124320 155310 125535 405165
Know the answer?
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
Similar Questions
Exercise 8-16 (Algo) Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan...
Exercise 8-16 (Algo) Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 9,000 12,000 11,000 10,000 In addition, 15,750 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $5,600. Each...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 32,000 October 22,000 August 74,000 November 8,500 September 43,000 December 9,000 The selling price of the beach umbrellas is $13 per unit. All sales are on account. Based on past experience, sales are collected in the...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 41,000 October 31,000 August 92,000 November 17,500 September 61,000 December 18,000 The selling price of the beach umbrellas is $13 per unit. All sales are on account. Based on past experience, sales are collected in the...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 30,000 October 20,000 August 70,000 November 10,000 September 50,000 December 10,000 The selling price of the beach umbrellas is $12 per unit. b. All sales are on account. Based on past experience, sales are collected...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a.The Marketing Department has estimated sales as follows for the remainder of the year (in units): The selling price of the beach umbrellas is $12 per unit. July 40,500 October 30,500 August 91,000 November 17,000 September 60,000 December 17,500 b. All sales are on account. Based on past experience, sales are collected in...
Exercise 8-10 Production and Direct Materials Budgets [LO8-3, LO8-4] Pearl Products Limited of Shenzhen, China, manufactures...
Exercise 8-10 Production and Direct Materials Budgets [LO8-3, LO8-4] Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company’s products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements: The finished...
Exercise 8-16 Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan Corporation...
Exercise 8-16 Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 11,000 14,000 13,000 12,000 In addition, 11,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $6,000. Each unit...
Question 2(19 Marks) Franklin Products Limited manufactures and distributes a number of products to retailers. One...
Question 2 Franklin Products Limited manufactures and distributes a number of products to retailers. One of these products, Super-Stick, requires four kilograms of material D236 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter—July, August, and September. Peak sales of Super-Stick occur in the third quarter of each year. To keep production and shipments moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at...
Problem 8-29 Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] The following data relate...
Problem 8-29 Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,800 Accounts receivable $ 25,200 Inventory $ 47,400 Building and equipment, net $ 114,000 Accounts payable $ 28,425 Common stock $ 150,000 Retained earnings $ 16,975 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 63,000 April $...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 140,000 Inventory 66,500 Plant and equipment, net of depreciation 227,000 Total assets $ 508,500 Liabilities and Stockholders’ Equity Accounts payable $ 88,000 Common stock 311,000 Retained earnings 109,500 Total liabilities and stockholders’ equity $ 508,500 Exercise 8-12...