Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MPQ Corporation is in the process of assembling its budget for the quarter ending March 31. Please see the following sales data: Sales Price =

MPQ Corporation is in the process of assembling its budget for the quarter ending March 31. Please see the following sales data:

  • Sales Price = $28 per unit
  • January Sales In Units = 1,650
  • February Sales In Units = 1,400
  • March Sales In Units = 1,550
  • Budgeted sales are 30% cash and 70% credit

Accounts Receivable, December 31 is $14,000. The $14,000 represents the uncollected portion of December sales.

The company prefers inventory equal to 27% of the net months sales in units. The December 31 balance of inventory is 480 units. The cost of inventory is $12 per unit. 35% of the purchases are paid in the month of purchase and 57% are paid in the subsequent month. At December 31, the Accounts Payable balance is $6,800. The $6,800 represents the purchases unpaid in December.

Miscellaneous Expenses are paid within the month incurred. These expenses consist of the following:

  • Freight - 3% of Sales
  • Sales Commissions - 8% of Sales
  • Lease on Factory - $3,750
  • Salaries (Office) - $2,200 per month

Please review the additional data below:

  • Depreciation Expense = $3,850 per month
  • Income Tax Rate = 38% (Income Taxes are paid on 4/1/2019 and 12/31/2019)
  • The company desires to keep a minimal $10,000 cash balance
  • Cash Balance, December 31 is $9,800
  • If there is a cash shortage, a loan is taken out to compensate at the end of the month. The interest on the loan is .8% per month, calculated from the beginning of the month balance on the loan. The interest must be paid each month. Please round to the nearest whole dollar.
  • There is more cash than the minimum required, the additional amount is applied to paying down the debt.
  • At December 31 there is not a balance on the loan.

Instructions

Prepare a master budget for each of the first three months during the calendar fiscal year. The master budget will include the following:

  1. Schedule of Cash Receipts

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

Contemporary Auditing

Authors: Michael C. Knapp

9th Edition

1133731244, 9781133731245

More Books

Students also viewed these Accounting questions

Question

mple 10. Determine d dx S 0 t dt.

Answered: 1 week ago