Question

In: Accounting

Choice is a retail company that sells specialized gardening products. The company is considering opening a...

Choice 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 $280000 of which 60 percent will be cash and the remainder will be on credit. The company expects all sales to increase at the rate of 25 percent per month for November and December. Sales in January Year 2 are expected to be $250000.

The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale.

Prepare a sales budget and a schedule of cash receipts using these facts and your excel template. Check your answers here before moving to the next part, by completing the cells requested in the chart below.

a. Sales Budget October November December Total-Qtr
Cash sales
Sales on account   
Total budgeted sales
b. Schedule of Cash Receipts October November December Total-Qtr
Current cash sales
Plus collections from A/R    
Total collections        

The cost of goods sold is 80 percent of sales. The company desires to maintain a minimum ending inventory equal to 30 percent of the next month’s cost of goods sold. (Ending inventory for December is based on budgeted January Year2 sales.)

Assume that all inventory purchases are made on account (on credit). The company pays 20 percent of accounts payable in the month of purchase and the remaining amount in the following month.

In excel, prepare an inventory purchases budget and a cash payments budget for inventory purchases. Use the check figures below before you continue.

c. Inventory Purchases Budget October November December Total-Qtr
Budgeted cost of goods sold
Plus desired ending inventory
Inventory needed
Less beginning inventory
Required purchases (on account)
d. Cash payments for inventory October November December Total-Qtr
Payment of current month's A/P    
Payment for prior month's A/P        
Total budgeted payments    

Solutions

Expert Solution

Choice Retail Company
Requirement a Sales Budget October November December Total-Qtr
Cash Sales 168000 210000 262500 640500
Sales on account 112000 140000 175000 427000
Total budgeted sales 280000 350000 437500 1067500
Requirement b Schedule of Cash Receipts October November December Total-Qtr
Current cash sales 168000 210000 262500 640500
Plus collection from A/R 0 112000 140000 252000
Total collections 168000 322000 402500 892500
Requirement c Inventory purchases Budget October November December Total-Qtr
Budgted cost of goods sold 224000 280000 350000 854000
Plus desired ending Inventory 84000 105000 75000 75000
Inventory Needed 308000 385000 425000 929000
Less : beginning inventory 67200 84000 105000 67200
Required purchases(on account) 240800 301000 320000 861800
Requirement d Cash Payments for Inventory
Payment of current month's A/P 48160 60200 64000 172360
Payment of Prior month's A/P 192640 240800 433440
Total Budgted payments 48160 252840 304800 605800

Related Solutions

Choice is a retail company that sells specialized gardening products. The company is considering opening a...
Choice 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 $280000 of which 60 percent will be cash and the remainder will be on credit. The company expects all sales to increase at the rate...
abulous is a retail company that sells specialized gardening products. The company is considering opening a...
abulous 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 $500000 of which 45 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...
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...
You are considering opening a retail establishment, ABC Company and need to make a number of...
You are considering opening a retail establishment, ABC Company and need to make a number of decisions regarding this new company and prepare a number of documents. Determine the type of organization you would like for your company (sole proprietor, partnership, corporation, etc.) and explain the advantages and disadvantages of your selection.
Easecom Company is a manufacturer of highly specialized products for networking video-conferencing equipment. Production of specialized...
Easecom Company is a manufacturer of highly specialized products for networking video-conferencing equipment. Production of specialized units is, to a large extent, performed under contract, with standard units manufactured to marketing projections. Maintenance of customer equipment is an important area of customer satisfaction. With the recent downturn in the computer industry, the video-conferencing equipment segment has suffered, causing a slide in Easecom’s performance. Easecom’s income statement for the fiscal year ended October 31, Year 1, is presented below. Easecom Company...
A retail company sells electronics products including mouse and keyboard. Mouse and keyboard are acquired from...
A retail company sells electronics products including mouse and keyboard. Mouse and keyboard are acquired from distinct suppliers. The monthly demand for a mouse is 2000, while the monthly demand for a keyboard is 1000 products. Mouse costs to company $12 and keyboard's cost are $18. The company has an annual holding cost of 20%, and the fixed shipment cost is $300. The procurement manager is not sure whether to order the mouse and keyboard separately or jointly. Assist with...
Exceptional Bouquets​ (EB) makes and sells flower bouquets. EB is considering opening a new store in...
Exceptional Bouquets​ (EB) makes and sells flower bouquets. EB is considering opening a new store in the local mall. The mall has several empty shops and EB is unsure of the demand for its product. The mall has offered EB two alternative rental agreements. The first is a standard​ fixed-rent agreement where EB will pay the mall $5,700 per month. The second is a royalty agreement where the mall receives $12 for each bouquet sold. EB estimates that a bouquet...
Raven Company sells a single specialized product. The company’s sales andexpenses for a recent month are...
Raven Company sells a single specialized product. The company’s sales andexpenses for a recent month are given below: TOTAL Sales $300,000 PER UNIT $60 45 $15 Less Variable Expenses Contribution Margin Less fixed expenses Net Operating Income Required: 180,000 120,000 70,000 $ 50,000 a) What is the monthly break-even point in units sold and in sales dollars? b) Without resorting to computations, what is the total contribution margin at the break-even point? c) How many units would have to be...
Rooney Manufacturing Co. produces and sells specialized equipment used in the petroleum industry. The company is...
Rooney Manufacturing Co. produces and sells specialized equipment used in the petroleum industry. The company is organized into three separate operating branches: Division A, which manufactures and sells heavy equipment; Division B, which manufactures and sells hand tools; and Division C, which makes and sells electric motors. Each division is housed in a separate manufacturing facility. Company headquarters is located in a separate building. In recent years, Division B has been operating at a net loss and is expected to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT