At Westonci.ca, we connect you with the answers you need, thanks to our active and informed community. Connect with a community of experts ready to help you find solutions to your questions quickly and accurately. Get quick and reliable solutions to your questions from a community of experienced experts on our platform.
Sagot :
Question Completion:
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 38,500 October 28,500 August 87,000 November 15,000 September 56,000 December 15,500 The selling price of the beach umbrellas is $14 per unit. 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 $504,000. 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. 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 91,550 feet September 30 ? feet 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 $49,290. Required: 1.
Answer:
Milo Company
July Aug. Sept. Total
1. Estimated sales $539,000 $1,218,000 $784,000 $2,541,000
2. Cash collections $489,300 $715,750 $1,026,900 $2,231,950
July Aug. Sept. Oct.
3. Production units 45,775 72,350 51,875 26,475
July Aug. Sept. Total
4. Quantity of Gilden (feet) 236,250 248,450 156,700 641,400
5. Cost of Purchases $141,750 $149,070 $94,020 $384,840
6. Cash disbursements for raw
material purchases $120,165 $145,410 $121,545 $387,120
Explanation:
a) Data and Calculations:
Selling price of the beach umbrellas = $14 per unit
June July Aug. Sept. Oct. Nov. Dec.
Estimated
sales 38,500 87,000 56,000 28,500 15,000 15,500
Sales $504,000 539,000 1,218,000 784,000 399,000 210,000 217,000
Sales Collection:
June July Aug. Sept. Total
Sales on credit 539,000 1,218,000 784,000 $2,541,000
Sales Collection:
30% month of sale 161,700 365,400 235,200 762,300
65% month following 327,600 350,350 791,700 1,469,650
5% uncollectible
Total collections $489,300 $715,750 $1,026,900 $2,231,950
July August September October
Beginning Inventory $75,600 $80,850 $182,700 $117,600
Ending Inventory 80,850 182,700 117,600 59,850
Sales 539,000 1,218,000 784,000 399,000
Finished Goods Inventory:
June July Aug. Sept. Oct. Nov. Dec.
Estimated
sales 36,000 38,500 87,000 56,000 28,500 15,000 15,500
Ending 5,775 13,050 8,400 4,275 2,250
Available 41,775 51,550 85,400 60,275 30,750
Beginning 5,400 5,775 13,050 8,400 4,275
Production 36,375 45,775 72,350 51,875 26,475
Raw materials inventory:
June July Aug. Sept. Oct.
Production units 36,375 45,775 72,350 51,875 26,475
Production needs 145,500 183,100 289,400 207,500 105,900
Ending inventory 91,550 144,700 103,750 52,950
Available materials 237,050 327,800 393,150 260,450
Beginning inventory 91,550 144,700 103,750 52,950
Purchases 236,250 248,450 156,700
Cost of Purchases $141,750 $149,070 $94,020
Payment for purchases:
Accounts payable $49,290
50% month of purchase 70,875 74,535 47,010
50% following purchase 70,875 74,535
Total payments $120,165 $145,410 $121,545
We hope our answers were helpful. Return anytime for more information and answers to any other questions you may have. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Your questions are important to us at Westonci.ca. Visit again for expert answers and reliable information.
