Excel Coursework

Succeeding in Business with Microsoft Excel 2013: A Problem-Solving Approach (New Perspectives)Author: Debra Gross, Frank Akaiwa, Karleen Nordquist 3 Customer Product Reviews ISBN-13: 9781285099149 ISBN: 1285099141 Edition: 1 Pub Date: 2013 Publisher: Cengage Learning It requires Level 1, 2, and 3 course work for each week. I have attached one of the weekly coursework for your review to know what is required, you must know the assignments from the book. It would take place each week as assignment instructions are sent out. It is 8 weeks of work. If someone has this book it will be helpful, though I can scan copies. I will just need an overall quote for each week with the time frame of 48 to 72 hours. Comments from Support Team: This is an example of week 1, the instructions do not come until each week. I have the sheets but no instructions as of yet. The book has instructions but may not be the same as what is required. I need a ballpark figure and an idea to know whether or not I should figure another alternative. 'armed in the produ.Ctiori' ot Shoe and the rai4.at which they are eribrint.d-boxe'S Moved per hour, pieces sewn per hour, and so 0.11. Also, listed is the labo'r rate to perform these tasks in dollars per hour. For example, 14 boxe.s can be delivered in an hour to the production line at a cost of $11 per hour. ® Cells A9:D15 (output area) shows these same tasks with the quantities required per shoe. For example, 0.25 boxes will be delivered for each shoe. If 14 boxes can be delivered in an hour at a cost of $11, how much will it cost to deliver 0.25 boxes? In these steps, your task is to troubleshoot this worksheet and correct any problems with formatting or formulas. Complete the following: 1. Open the workbook named Laborodsx located in the Chapter 1 folder, and then save the file as Labor Costs.xlsx. 2. Adjust the column widths, as necessary, so that all information is fully displayed. 3. Format the values in the Production Rate and $/Hour columns with the Comma Style. Format cell D2 with a dollar sign aligned at the left of the cell. 4. Address the error message in cell B10. 5. Correct the formula in cell D 10 so that it accurately calculates the cost of delivering boxes for one shoe. 6. Check the formulas for the other manufacturing tasks to ensure they are written correctly and that the worksheet can be easily updated later if any inputs change.. The inputs are the Production Rate, Unit, $/Hour, and Quantity/Shoe. Check that the formula to suminarize the labor costs is correct, and modify as needed. 7. Format range D10:D15 so that the values align on the decimal point and display two decimal places for all the values in colunin D. Include a dollar sign in cells D10 and D15. 8. Format cells B10:B14 with the Comma Style with two decimal places. 9. The labor cost of sewing logos onto the leather was accidentally omitted from the manufacturing tasks. There are two logos per shoe that need to be sewn. on.. Insert a: new row just below the row containing the Attachment of Appliques, and complete . the data inputs and outputs to calculate the labor cost of sewing these logos. 10. Adjust the Total Labor cost accordingly. 1 1 . Add the title TZEdge Labor Analysis at the top of the worksheet.,.Center:and:rnerge. the title over the columns containing values. Format the title with a light blue.backgr6iind....choose a blue color in the Theme Colors section. 12. Create a custom page header to contain your name, the name of the company, and today's date. 13. Save and close the Labor Costs.xlsx workbook.