Points: $25$

Due Date: February $5,2024,9$:$00$ am

Please read all of the instructions carefully before completing the exam.

All work must be completed independently.

Part $1$: Use the information in Part $1$ for Aloha Candies Company to

complete a Cost of Goods Manufactured Statement and a Cost of

Goods Sold Statement for the year ended $2024.$ All reports should be

prepared in Excel with good form.

The following cost and inventory data were taken from the records of the

Aloha Candies Company for the year $2024$:

Costs incurred:

Depreciation, factory equipment

Depreciation, office equipment

Supplies, factory

Maintenance, factory equipment

Utilities, factory

Sales commissions

Indirect labor

Rent, factory building

Purchases of direct materials $($net$)$

Direct labor

Advertising expenses

Inventories:

Part $2$: Use only the information in Part $2$ to prepare a Contribution

Margin Income Statement and a Gross Margin Income Statement for

the month of July $2024.$ Assume the company produced and sold $5,000$

units and there were no units in inventory on July $1,2024.$ All reports

should be prepared in Excel with good form.

The cost accountant for the Aloha Candies Manufacturing Company has

provided you with the following information for the month of July:

Direct labor

Variable costs per unit

Total Fixed Costs

Direct materials

Manufacturing overhead

Marketing costs

$$5\mathrm{.}30$

$$50,000$

Administrative costs

$$2\mathrm{.}90$

$$75,000$

Selling price

$$210\mathrm{.}00$