Assignment 1 (similar to Exercise 3-46) Starlite Company has the following financial data for the fiscal year ending December 31. Click here to download the Assignment 1 Excel File of Financial Data. Briefly review the Excel file and note that amounts transferred out are displayed as negative numbers. Proceed to the assignment steps below. Assignment 1 Steps: Open a new Tableau Workbook from the File menu. Select the Connect to Data option in the Data tab on your blank worksheet page, or you can select Data Source in the bottom left hand corner. Next, select Microsoft Excel in the list of connection sources. You will then select the Excel data file you just downloaded in your file explorer. Notice that there are some zeros in the data. The correct amount of these steps is not zero, instead you will need to solve for these variables to answer the questions. Within the Sheet1 Tab, drag and drop Amount from the Data pane into the columns shelf and make sure Tableau is summing the amounts. Drag and drop Inventory from the Data pane into the rows shelf. Be sure to order these inventory accounts in the same sequence as shown in the Excel data file you have downloaded. You can order these inventory accounts by clicking, dragging, and dropping them. Drag and drop Step from the Data pane into the Rows shelf (to the right of Inventory). Drag and drop Category from the Data pane onto the Color mark. Drag and drop Amount from the Data pane onto the Label mark. Save your file, then answer the questions below using the Tableau dashboards you have created. Step Amount Category Inventory 1. Beginning Balance, January 1 28,000 Beginning Balance Raw Materials 2. (+) Purchases (RM Purchases) 220,000 Addition Raw Materials 3. (-) Ending Balance 20,000 Ending Balance Raw Materials 4. = Transferred Out (RM used) (228,000) Transferred Out Raw Materials 5. (+) Direct Labor (152,000) Transferred Out Direct Labor 6. (+) Fixed Overhead 300,000 Addition Overhead 7. (+) Variable Overhead - Addition Overhead 8. = Total Factory Overhead (390,000) Transferred Out Overhead 9. Beginning Balance, January 1 40,000 Beginning Balance WIP 10. (+) Additions (RM used) 228,000 Addition WIP 11. (+) Additions (DL used) 152,000 Addition WIP 12. (+) Additions (OH used) 390,000 Addition WIP 13. (-) Ending Balance, December 31 55,000 Ending Balance WIP 14. = Transferred Out (COGM) (755,000) Transferred Out WIP 15. Beginning Balance, January 1 35,000 Beginning Balance FG 16. (+) Additions (COGM) 755,000 Addition FG 17. (-) Ending Balance, December 31 15,000 Ending Balance FG 18. = Transferred Out (COGS) - Transferred Out FG

1. What is the variable factory overhead costs for the year?

2. What are the total Manufacturing Costs?

3. What is the total Cost of Goods manufactured?

4. What are the total Goods Available for Sale?

5. What is the total Cost of Goods Sold?