REQUIREMENTS

A$.$ Develop an Excel spreadsheet that includes the content outlined below in items $1$ through $3---$ use solution example provided where item was assigned and discussed in class.

B$.$ The Excel Spreadsheet should be able to change variables for units produced and units sold:

a$.$ Base $-4000$ units produced and $4000$ units sold

b$.$ Change $1-4500$ units produced and $4,300$ units sold

c$.$ Change $2-4800$ units produced and $4,700$ units sold

The Spreadsheet should provide the following schedules and financial statements

$1.$ Basic Schedule of Cost of Goods Manufactured

DM

DL

MO

Total Manfacturing Costs

Total and Per Unit Cost Columns for each of the above.

$2.$ Balance Sheet $-$ Finished Goods Inventory Account only

# of units in FG Inventory

Total and Per Unit $ Amounts for FG Inventory

$3.$ Income Statement $-$ Contribution Approach

Sales

Less Variable Costs

$=$ Contribution Margin

Fixed Costs

$=$ Net Income

Total and Per Unit $Amounts for Sales, VC and CM

Total $ amounts for FC and NI

Create one sheet for each of the above scenarios $-$ Base, Change $1,$ Change $2$