Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions