Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
How to compute these from the table in the image in an excel In Column F, create a column titled Labor Cost . Using a
How to compute these from the table in the image in an excel
- In Column F, create a column titled Labor Cost. Using a formula, compute the Labor Cost for each product
- In Column G, create a column titled Unit Cost: Using a formula that includes Materials, Labor Costs and Shipping Costs.
- In Column H, create a column titled Unit Labor Cost %. Using a formula, compute the percentage of labor cost for each unit. 2 decimal places.
- Using a formula, compute the Totals for Columns B-G [excluding H.] Fill cell H19, with a light blue, shade.
- Center the data in columns C, D + E, and format column E data with a 1,000 separator (,) and 2 decimal places.
- In Column I, create a column titled Unit % Total Sales. Using a formula, compute the % of each unit against the total sales. 4 decimal places.
- In Column J, create a column titled Overhead per Unit. Using a formula, compute the monthly overhead costs for each sold unit.
- Using a formula, compute the totals for I17 and J17.
- In the Title in A1, after Whovian Industries, add your Last Name and center across the sheet.
- Center all the titles, use a light green fill on the data in rows 2 + 3.
- Sort the Products with their relative data, in Ascending [Alpha] order. Make sure the data stays aligned correctly
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started