Objective: This assignment will serve to get you acclimated to Excel, and also push you to analytically assess how product costs flow. Instructions: Assume you are a CEO of your choice of a manufacturing company. The company can be real or fictional. Summarize your main product costs via following the outline below, and create an income statement and balance sheet for year 1. The only requirements are:

Requirements:

Cover the Outline below

Use any numbers you like, as long as the totals / calculations flow properly

Show your work via formulas (i.e. a + b = c) throughout.

Outline: 4 Income statement for the end of year one 10 30 * Describe and quantify the following breakout of inventory that feeds your balance sheet: 20 *** Describe and quantify the following breakout of Manufacturing overhead: *** Describe and quantify the following breakout of Manufacturing overhead: REQUIRED - Summarize in words what this balance is comprised of (a sentence or two is fine, can include examples). Let your creative juices flow, but make sure the examples you use are in line with the nature of your company. Outline: 4 Income statement for the end of year one 10 30 * Describe and quantify the following breakout of inventory that feeds your balance sheet: 20 *** Describe and quantify the following breakout of Manufacturing overhead: *** Describe and quantify the following breakout of Manufacturing overhead: REQUIRED - Summarize in words what this balance is comprised of (a sentence or two is fine, can include examples). Let your creative juices flow, but make sure the examples you use are in line with the nature of your company