Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Home Safe Corporation buys home security systems then resells them $300 per unit. The company budgeted the following sales for the upcoming months: March

image text in transcribed

The Home Safe Corporation buys home security systems then resells them $300 per unit. The company budgeted the following sales for the upcoming months: March 490 units April 400 units May 510 units June 500 units All sales to customers are made on account and recent experience shows that 70% of sales are collected in the month of the sale and 30% in the month after the sale. The company purchases its product for $220 per unit and all purchases are paid in full in the month the purchase is made. The company maintains ending inventory equal to 20% of the next month's unit sales and had 80 units in inventory on March 1st. The company's advertising is fixed at $1,500 per month, has other administrative costs of $12,500 per month and salaries of $20,000 per month; all selling and administrative expenses are paid in full each month. The company plans to give its salaried employees a one-time bonus of $5,000 (total) in May. To help offset what is otherwise expected to be a slow month, the company is planning a 10% off the price promotional sale during the month of April and the estimated impact in sales volume is already included in the April unit sales forecast The company plans to purchase $30,000 of equipment in April and another $20,000 in May and will take out a $60,000 loan in April to help fund those purchases. The company had a cash balance of $35,000 and an accounts receivable balance of $22,000 on February 28th. Required: a. Given the information above, prepare a sales budget, purchases budget, budgeted income statement, cash budget and a budgeted balance sheet (for cash, accounts receivable, inventory, equipment and liabilities) for March, April and May. b. Given your results, briefly comment on the company's expansion plans and give two related and specific recommendations for the company

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions