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 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 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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 15, 2021

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

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:

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.

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