Question

Solomon Company is a retail company that specializes in selling outdoor camping equipment. The company is...

Solomon 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 $310,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 month’s cost of goods sold. However, ending inventory of December is expected to be $13,300. 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,300
Sales commissions 4 % of Sales
Supplies expense 2 % of Sales
Utilities (fixed) $ 2,700
Depreciation on store fixtures (fixed)* $ 5,300
Rent (fixed) $ 6,100
Miscellaneous (fixed) $ 2,500

Solomon 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:

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.

Homework Answers

Answer #1

                                                                                 

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Walton Company is a retail company that specializes in selling outdoor camping equipment. The company is...
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 the following tasks: Problem 14-23 Part 1 Required October sales are estimated to be $390,000, of which 40 percent will be cash and 60 percent will be credit. The...
Problem 7-23A Preparing a master budget for retail company with no beginning account balances LO 7-2,...
Problem 7-23A Preparing a master budget for retail company with no beginning account balances LO 7-2, 7-3, 7-4, 7-5, 7-6 [The following information applies to the questions displayed below.] Campbell 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...
Required information Problem 14-23 Preparing a master budget for retail company with no beginning account balances...
Required information 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.] 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...
Esteem is a retail company that sells specialized gardening products. The company is considering opening a...
Esteem is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s operation. You have gathered the following information: October sales are estimated to be $350000 of which 40 percent will be cash and the remainder will be on credit. The company expects all sales to increase at the rate...
Admire is a retail company that sells specialized gardening products. The company is considering opening a...
Admire is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s operation. You have gathered the following information: October sales are estimated to be $300000 of which 45 percent will be cash and the remainder will be on credit. The company expects all sales to increase at the rate...
Solomon Publications established the following standard price and costs for a hardcover picture book that the...
Solomon Publications established the following standard price and costs for a hardcover picture book that the company produces. Standard price and variable costs Sales price $ 36.80 Materials cost 8.70 Labor cost 3.80 Overhead cost 5.70 Selling, general, and administrative costs 6.30 Planned fixed costs Manufacturing overhead $ 131,000 Selling, general, and administrative 44,000 Solomon planned to make and sell 31,000 copies of the book. Required: a. - d. Prepare the pro forma income statement that would appear in the...
I ONLY NEED THE INVENTORY PURCHASES BUDGET (C) AND THE CASH BUDGET (G). Hint - not...
I ONLY NEED THE INVENTORY PURCHASES BUDGET (C) AND THE CASH BUDGET (G). Hint - not all the numbers in the two charts just get added across. I'm assuming that is to find the total-qtr. number. Please help! Admire is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s...
Cooper Company, a retailer of camping supplies has budgeted activity for January using the following data:...
Cooper Company, a retailer of camping supplies has budgeted activity for January using the following data: Cash sales $26,200 Credit sales (60% collected in month of sale) 409,900 Selling and administrative costs (including depreciation) 52,610 Depreciation expense 4,890 Merchandise Inventory, January 1 21,110 Merchandise Inventory, January 31 21,580 Beginning cash balance 2,730 Minimum cash balance required 2,300 Cost of goods sold is 57% of Cooper’s selling price All purchases are paid in cash Selling and administrative costs are paid in...
Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet...
Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet has requested a cash budget for October. After examining the records of the company, you find the following: Cash balance on October 1 is $1,110. Actual sales for August and September are as follows: August September Cash sales $6,000     $4,500     Credit sales 58,000     62,000         Total sales $64,000     $66,500     Credit sales are collected over a three-month period: 40 percent in the month of sale, 36...
Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet...
Cash Budget Janet Wooster owns a retail store that sells new and used sporting equipment. Janet has requested a cash budget for October. After examining the records of the company, you find the following: Cash balance on October 1 is $1,118. Actual sales for August and September are as follows: August September Cash sales $6,000 $4,500 Credit sales 58,000 62,000 Total sales $64,000 $66,500 Credit sales are collected over a three-month period: 40 percent in the month of sale, 36...