# Skaters-Inc-plans-to-sell-90-000-skateboards-next-quarter-at-a-price-of-36-per-unit

Hello,

THIS PROJECT REQUIRES EXCEL AND IS DUE: 15 OCT 2017 BY 12:00 PM EST.

ASSIGNMENT

Part I

Skaters, Inc. plans to sell 90,000 skateboards next quarter at a price of \$36 per unit. Production costs are \$14.40 per unit. Selling and administrative expenses are: variable, \$7.20 per unit; and fixed, \$604,800 per quarter. What are the budgeted earnings for next quarter? (Do not consider federal income taxes.)

Using excel, show the analysis in a table format. Write a one-paragraph interpretation of the information presented in the table.

Part II

Houston Corporation considers materials and labor to be completely variable costs. Expected production for the year is 50,000 units.

At that level of production, direct materials cost is budgeted at \$198,000, and direct labor cost is budgeted at \$450,000. Prepare a flexible budget for materials and labor for possible production levels of 52,500, 60,000, and 67,500 units of product.

Assume that in the previous exercise the actual production was 60,000 units, materials cost was \$247,000, and labor cost was \$510,000. What are the budget variances?

Using excel, show the analysis in a table format. Write a one-paragraph interpretation of the information presented in the table.

REQUIRED REFERENCES: NONE

PROJECT EXPECTATIONS:

1. DUE: 15 OCT 2017 BY 12:00 PM EST.

2. Use Excel to show these computations, and write comments / explanations below the computations in Excel.

3. This project will be reviewed for, both, content and the clarity.