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 month’s 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: Schedule of Cash Disbursements for Merchandise Purchases Schedule of Cash Disbursements for Selling and Administrative Expenses Cash Budget, including information on the loan balance

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 month’s 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: Schedule of Cash Disbursements for Merchandise Purchases Schedule of Cash Disbursements for Selling and Administrative Expenses Cash Budget, including information on the loan balance

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter9: Profit Planning And Flexible Budgets

Section: Chapter Questions

Problem 72P: Cash Budget The controller of Feinberg Company is gathering data to prepare the cash budget for...

See similar textbooks

Instructions

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

Schedule of Cash Disbursements for Merchandise Purchases
Schedule of Cash Disbursements for Selling and Administrative Expenses
Cash Budget, including information on the loan balance
Budgeted income statement for the quarter

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.