Transcribed image text:
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: 1. Cover the 'Outline' below 2. Use any numbers you like, as long as the totals / calculations flow properly 3. Show your work via formulas (i.e, a+b=c ) throughout. - Describe and quantify the following breakout of inventory that feeds your balance sheet: 5> Raw materials (RM) REQUIRED 5 6> Work in process (WIP) " REQUIRED 10 7> Finished Goods (FG) REQUIRED 5 20 "Describe and quantify the following breakout of WIP: 20 ** Describe and quantify the following breakout of Manufacturing overhead: 11 >> indirect Materials REQUIRED 10 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.