PLEASE USE EXCEL FORMAT DESCRIBED!!! THANKS!!

Develop a mock product costing and valuation table for a business model. Be sure to include all costs involved in the production of good and/or service. Break down into as many subcategories as needed, such as variable, fixed, direct, or indirect. Be sure to assign overhead to each type of product and/or service.

EXAMPLE: Company A manufactures park benches

• Direct Material: The cost of wood/cement/metal to create the bench
• Direct Labor: The cost of the salary/wages/benefits of the manufacturing staff to create the benches.
• Manufacturing Overhead (material): Cost of nails/screws to hold the bench together
• Manufacturing Overhead (labor): Security to watch the factory at night, or admin staff to keep the company running
• Manufacturing Overhead: Utilities, and other potential overhead costs.

Week 3 Assignment