Instructions: Here is the data for the project.

Do NOT change amounts in blue highlight cells. Reference these cells throughout the project in your formulas as needed. Use formulas to calculate the correct amount for these cells. Then reference the cells throughout the project as needed. See cell D$19$ for an example as the formula has been entered for you in this cell.

Data for the company that might be used in all analysis. Data for specific analyses is listed below and highlighted by tab color. Fixed Manufacturing Overhead

Depreciation included in Fixed Manufacturing Overhead above

Sales Commissions $($percent of sales revenue$)$

Administrative Salaries

Building Rent

Admin. Utilities $($fixed$)$

Other Fixed Admin

Other Variable Admin $($percent of total direct material costs$)$

Sales Salaries

Additional Information for Job $5431$ Job Cost Calculations: nstructions: Prepare a Traditional Income Statement for the month of January in proper form. Use formulas and links to the the Data Entry page whenever possible.

Hint: For this statement use total manufacturing overhead costs as given. You do not need to calculate a predetermined overhead rate. Additional Information for Job $5431$ Job Cost Calculations:$\backslash$$

$22\mathrm{.}00\backslash$$

$28\mathrm{.}00\backslash$$

$30\mathrm{.}00\backslash$$

$21\mathrm{.}00$