Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the month of August and has assembled the following information to assist in
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the month of August and has assembled the following information to assist in the budget preparation:
- Budgeted sales units are 30,000 (July), 70,000 (August), 50,000 (September) and 20,000 (October)
- Selling price per unit:$15
- Cash collections:40% in the month of sale.55% in the month following the sale.5% are uncollectible.
- The company maintains finished goods inventories equal to 20% of the following month's sales.
- Each beach umbrella requires 5 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.
- Raw material cost is $0.80 per foot of Gilden.
- The beginning balance of raw materials for August will be 134,000 feet of Gilden.
- 60% 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 balance on August 1 for purchases of Gilden during July will be $82,400.
Answer the following questions:
- What is the August sales budget in dollars?
- How much money will Milo collect during the month of August?
- How many units should be produced in the month of August?
- How many feet of raw materials (Gilden) should be purchased in August?
- What will be the cost of raw materials for the month of August?
- What will be the cash disbursements in August?
Enter you answers in the same order as above.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started