Question
Murni company produces packed food. The following are the details of the company. Budgeted sales for the next five months are: April 80,000 units May
Murni company produces packed food. The following are the details of the company. Budgeted sales for the next five months are: April 80,000 units May 90,000 units June 90,000 units July 30,000 units August 80,000 units. The selling price is $12 per unit. All sales are on account. Murni collection pattern is: 70% collected in the month of sale, 20% collected in the month following sale, 10% collected in the third month following sale, The March 31 accounts receivable balance of $13,000 will be collected in full The management wants ending inventory to be equal to 15% of the following months budgeted sales in units. On March 31, 8,000 units were on hand. At Murni Company, 8 pounds of material A and 3 pounds of material B are required per unit of product. Management wants materials on hand at the end of each month equal to 20% of the following months production. On March 31, 8,000 pounds of material A and 3,000 pounds of material B are on hand. Material cost is $0.50 per pound for A and $0.30 for B 80% of a months purchases is paid for in the month of purchase; the balance is paid in the following month. The March 31 accounts payable balance is $8,000. REQUIRED: Using Microsoft Excel, prepare the following budgets for quarter two for Murni company. 1. Sales Budget 2. Expected Cash Collections 3. Production Budget 4. Direct Materials Budget 5. Expected Cash Disbursement for Materials
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