Starlite Company has the following financial data for the fiscal year ending December 31.

Click here to download the 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:

1. 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.
2. Within the Sheet1 Tab, drag and drop Amount from the Data pane into the columns shelf and make sure Tableau is summing the amounts.
3. 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.
4. Drag and drop Step from the Data pane into the Rows shelf (to the right of Inventory).
5. Drag and drop Category from the Data pane onto the Color mark.
6. Drag and drop Amount from the Data pane onto the Label mark.

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

Answer rating: 100% (QA)

Working Beginning raw materials 28000 Add Raw material purchases 220000 Raw ... View the full answer