Prepare a direct materials budget for gilden
Course:- Managerial Accounting
Reference No.:- EM13173052

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Managerial Accounting

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).

1995_Prepare a production budget for each of the month.PNG

(b)All sales are on account. Based on past experience, sales are collected in the following pattern:
30% in the month of sales
65% in the month following sales
5% uncollectible
Sales for June totaled $300,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 beginning and end of the quarter will be:

21_Prepare a production budget for each of the month1.PNG

(e)Gilden costs $0.80 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 $76,000.


1. Prepare a sales budget, by month and in total, for the third quarter. (Show your budget in both units and dollars.) Also prepare a schedule of expected cash collections, by month and in total, for the third quarter.

2. Prepare a production budget for each of the months July-October.

3. Prepare a direct materials budget for Gilden, by month and in total, for the third quarter. Also prepare a schedule of expected cash disbursements for Gilden, by month and in total, for the third quarter.


Put your comment

Ask Question & Get Answers from Experts
Browse some more (Managerial Accounting) Materials
Analyse and discuss the costs and benefits for firms disclosing related party transaction disclosure in the context of stakeholder theory, positive accounting theory, legitimi
Mattresses-A-Million produces Pillow-Top mattresses. They have been using a volume-based costing system to allocate overhead based on direct labor-hours. The Pillow-Top requ
Differentiate between the Generally Accepted Accounting Principles and the International Financial Reporting Standards for their impact on financial statements - Determine a
Some citizens complained to Victoria city council members that there should be equal protection under the law against the occurrence of crimes. The citizens argued that this e
Should Breakfasttime's management decide to process Crummies into the mulch? Why - Suppose the company does process Crummies into the mulch. Use the net-realizable-value metho
Calculate the increase or decrease in profits for the three divisions and the company as a whole (four separate computations) if the agreement is enforced. Explain your though
Explain why the product-line income statement as presented is not suitable for analysis and decision making and describe an alternative income-statement format that would be m
Do you think that the Household Products Division should include subjective measures of employee satisfaction and customer satisfaction in its balanced scorecard? Explain.