1. Sales Budget | |||
Description | Jan | Feb | Mar |
Sales in units | 1200 | 1000 | 1600 |
Price p.u | $ 25 | $ 25 | $ 25 |
Total Sales | $ 30,000 | $ 25,000 | $ 40,000 |
2. Merchandise Purchase Budget | |||
Description | Jan | Feb | Mar |
Projected next month sales (in units) | 1000 | 1600 | 1400 |
Ending Inventory Percentage | 30% | 30% | 30% |
Desired Ending Inventory | 300 | 480 | 420 |
Expected sales (in units) | 1200 | 1000 | 1600 |
Total units required | 1500 | 1480 | 2020 |
Opening Inventory | 340 | 300 | 480 |
Total Purchases | 1160 | 1180 | 1540 |
Budgeted Cost per unit | $ 10 | $ 10 | $ 10 |
Projected Purchases | $ 11,600 | $ 11,800 | $ 15,400 |
3. Selling Expense Budget | |||
Description | Jan | Feb | Mar |
Budgeted Sales | 30000 | 25000 | 40000 |
Variable costs (as percent of sales) | 12% | 12% | 12% |
Variable Selling Expenses | 3600 | 3000 | 4800 |
Fixed Expenses | 7200 | 7200 | 7200 |
Projected Selling Expenses | $ 10,800 | $ 10,200 | $ 12,000 |
4. Summary of cash Receipts from Customers | |||
Description | Jan | Feb | Mar |
Budgeted Sales | $ 30,000 | $ 25,000 | $ 40,000 |
Cash Sale (40%) | $ 12,000 | $ 10,000 | $ 16,000 |
Credit Sale (60% to be collected in following month) | $ 10,000 | $ 18,000 | $ 15,000 |
Total Cash collection | $ 22,000 | $ 28,000 | $ 31,000 |
5. Summary of Cash Disbursements of merchandise purchases | |||
Description | Jan | Feb | Mar |
Projected Purchases | $ 11,600 | $ 11,800 | $ 15,400 |
Cash Payment (in the month of purchase) | $ 4,640 | $ 4,720 | $ 6,160 |
Cash Payment (after 1st month of purchase) | $ 8,000 | $ 6,960 | $ 7,080 |
Total Cash disbursed | $ 12,640 | $ 11,680 | $ 13,240 |
6. Cash Budget | |||
Particulars | Jan | Feb | Mar |
Beginning cash Balance | $ 10,200 | $ 10,000 | $ 14,868 |
Budgeted Cash Receipts | $ 22,000 | $ 28,000 | $ 31,000 |
Total Cash available | $ 32,200 | $ 38,000 | $ 45,868 |
Cash Disbursements | |||
Payments for Selling Expenses(from point 3) | $ 10,800 | $ 10,200 | $ 12,000 |
Payments for Merchandise | $ 12,640 | $ 11,680 | $ 13,240 |
Payments for interest | $ 12 | ||
Total Cash Disbursed | $ 23,440 | $ 21,892 | $ 25,240 |
cash surplus/deficit | $ 8,760 | $ 16,108 | $ 20,628 |
Minimum Cash balance to be kept | $ 10,000 | $ 10,000 | $ 10,000 |
Financing | |||
Borrowing | $ 1,240 | ||
Repayments | $ 1,240 | ||
Net cash flow from financing | |||
Ending cash Balance | $ 10,000 | $ 14,868 | $ 20,628 |
Add title, thank you! Hammerly Corporation is preparing its m March 31. It sells a single...
The first attached page is the details. The last three are the master budget that needs to be completed. Please use the master budget provided so i can understand. The steps on the master budget are labled 1-7. Thank you ...) Oxford, Inc., is preparing its master budget for the quarter ended June 30. It sells a single product for $40 each. Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the...
Please prepare the master budget, but please use template i provided. The template is the last 3 pages i attached and the steps are numbered.The first page is the actual question. Thank you ...) Oxford, Inc., is preparing its master budget for the quarter ended June 30. It sells a single product for $40 each. Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. At March 31. the balance in...
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...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to deckers manufacturing s operation Current Assets as of December 31 (prior year): Cash 4600 Accounts receivable, net 47000 Inventory 15100 Property, plant, and equipment, net 123000 Accounts payable. 43000 Capital stock. 123500 Retained earnings. 23100 a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable at $12 per unit throughout the budget period. Sales...
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...
Aztec Company sells its product for $170 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 4,500 $ 765,000 May (actual) 2,000 340,000 June (budgeted) 6,000 1,020,000 July (budgeted) 5,000 1,019,000 August (budgeted) 3,600 612,000 All sales are on credit. Recent experience shows that 24% of credit sales is collected in the month of the sale, 46% in the month after the sale, 25% in the second month after the sale, and 5% proves to be uncollectible....
LBL Corporation is preparing its master budget for the first quarter of the upcoming year. The following contains detail on LBL’s operations necessary for their master budget: LBL Corporation is preparing its master budget for the first quarter of the upcoming year. The following contains detail on LBL's operations necessary for their master budget: Sales Information Actual Projected Sales are as follows: December (Prior Year; Actual): $75,000 January (Estimated) $85,000 February (Estimated): $91,000 March (Estimated): $96,000 April (Estimated): $112,000 May...
Question 3 (10 marks) BBG Limited is now in the process of preparing its cash budget for October. The nning cash balance is $44,000. Budgeted cash receipts total $318,000 and budgeted cash disbursements total $344,000. The desired ending cash balance is $60,000. BBG can borrow up to $500,000 from Hang Seng Bank whenever they are in need of cash, with interest not due until the following month. Required: Prepare the BBG's cash budget for October in good form. Question 4...
Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total...
Problem 14-23 Preparing a master budget for retail company with no beginning account balances LO 14-2, 14-3, 14-4, 14-5, 14-6 [The following information applies to the questions displayed below.] Walton Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, 2019. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned...