Reference no: EM131662383

Leo Company Master Budget and Flexible Budget Final Exam

1. Leo Company expects its Sales in January to be 2,400 units at an expected sales price of $110 per unit and expects Sales to grow by 2% each month. 

2. 40% of all sales are cash sales and the remaining 60% are credit sales.  For credit sales the company expects to collect 10% of credit sales in the month of the sale, the remaining 90% in the month after the sale. 

3. The cost of goods sold is equal to 62% of sales. 

4. Leo Company likes to keep an ending inventory equal to 10% of next month's expected cost of goods sold. 

5. All purchases of inventory are on account, and the company pays for 80% of all purchases in the month of the purchase, 20% in the month after the purchase. 

6. The company pays its sales force a commission equal to 5% of sales. 

7. The company also believes that its supplies expense is equal to $4,000 plus 2% of sales. 

8. Salaries are $12,000, Rent is $4,500 per month, Advertising is $3,000 per month, Depreciation is $1,000 per month, and Utilities are $1,200 per month. 

9. The company purchased an insurance policy covering 12 months for $24,000 on January 1. 

10. All selling and administrative expenses are paid in the month they are incurred except for commissions that are paid in the month after they are earned and the insurance which is paid one year in advance. 

11. On January 31, Leo Company purchased Land costing $58,000.  Leo paid cash for the land.

12. Interest on long-term debt is equal to 1% of the beginning balance and is paid each month.  The company must maintain a minimum balance in cash of $15,000 and will use any cash surplus to pay down long-term debt.  The company borrows cash in $1,000 increments.

13. The company is subject to a 25% income tax rate.  The company pays income taxes in the month after they are accrued (expensed).

14. In January, the company will declare a $10,000 cash dividend that it will pay in February.

15. The company had a beginning balance sheet (as of January 1) as follows:

ASSETS:			LIAB & STOCKHOLDERS EQUITY
Current Assets			Current Liabilities
Cash	$15,200		Accounts Payable	$9,828
Accounts Receivable	$129,600		Commissions Payable	$8,100
Prepaid Insurance	0		Income Taxes Payable	$5,000
Inventory	$10,800		Dividends Payable	$-0-
Total Currents Assets	$155,600		Total Current Liabilities	$22,928
Property, Plant, & Equipment			Long Term Debt	$140,000
Land	$10,000		Stockholders Equity
Equipment	$40,000		Common Stock	$10,000
Accumulated Depreciation	($20,000)		Retained Earnings	$12,672
Total PPE	$30,000		Total Stockholders Equity	$22,672
Total Assets	$185,600		Total Liab & SE	$185,600

Actual unit sales were 2,125.  Actual Results for the month of January are as follows:

Sales	$244,375
Cost of Sales	$144,500
Gross Profit	$99,875
Operating Expenses
Commissions Expense	$9,775
Salaries	$12,500
Supplies Expense	$11,331
Rent Expense	$4,800
Advertising Expense	$2,000
Depreciation Expense	$1,000
Utilities Expense	$1,300
Insurance Expense	$2,050
Interest Expense	$1,400
Pretax Income	$53,719
Income Tax Expense	$4,000
Net Income	$49,719

Note that these values have been rounded to the nearest dollar.  For the template, it is necessary that you link values and not type values.

REQUIRED:

1. Prepare a Master Budget for January, February and March.

2. Determine the Activity Variances, Revenue Variance and Spending Variances for January for Leo Company.

3. Calculate the following (using the planning budget values to answer the following):

a. Contribution margin percentage (ratio).

b. Sales at the breakeven point.

c. Dollar margin of safety.

d. Sales dollars needed to achieve a $50,000 before tax net income.

e. Sales dollars needed to achieve a $50,000 after tax net income.

Attachment:- Assignment Files.rar