Skaters, Inc. plans to sell 90,000 skateboards next quarter at a price of $36 per unit

Get perfect grades by consistently using our writing services. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

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.

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an excellent paper from our writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper