Question
Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, 2019.
Munoz 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 the following tasks:
Required
-
October sales are estimated to be $400,000, of which 45 percent will be cash and 55 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget.
-
The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts.
-
The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next months cost of goods sold. However, ending inventory of December is expected to be $13,900. Assume that all purchases are made on account. Prepare an inventory purchases budget.
-
The company pays 80 percent of accounts payable in the month of purchase and the remaining 20 percent in the following month. Prepare a cash payments budget for inventory purchases.
-
Budgeted selling and administrative expenses per month follow:
Salary expense (fixed) | $ | 19,900 | |
Sales commissions | 4 | % of Sales | |
Supplies expense | 2 | % of Sales | |
Utilities (fixed) | $ | 3,300 | |
Depreciation on store fixtures (fixed)* | $ | 5,900 | |
Rent (fixed) | $ | 6,700 | |
Miscellaneous (fixed) | $ | 3,100 | |
-
Prepare a pro forma income statement for the quarter.
-
Prepare a pro forma balance sheet at the end of the quarter.
-
Prepare a pro forma statement of cash flows for the quarter.
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