SUNY Westchester Community College General Instructions J. Pivot table #3 (Check figure Cell F936 should be $ 1,793) Managerial Accounting Before you start a. What is the revenue generated by each job? How much revenue did job 3515 Chapter 4 Lab - Ivy Corporation" At home, before starting this in lab, watch the tutorial video and practice using the tutorial data generate? Learning Objectives et, which is similar but smaller than the actual data set: D. What are the totals of direct material, direct labor, and manufacturing overhead When you have finished this assignment, you should be able toi Here is the link to the firtorial (link) and to the tutorial data set (link) costs for each job? How much direct materials did job 3535 use? in class c. What is the gross profit generated by each job? Answer the questions in d. 1 Create pleat tables to analyze data. 2. Format numbers in pivot tables. d. Which job generated the most gross profit? Which generated the least gross Create pivot tables (link) in separate worksheets to calculate answers for each of the following 1 Calculate gross profit for a man cturer with no herventories requirements. Rename each of the phot table worksheets (link) from the default sames to profit? Hint: Sort the pivot table by gross profit (lab). 4. Rename worksheets in tabs with different colo "Pivot table 1," "Pivot table 2," etc Format dollar amounts in all pivot tables with the 4. Pivot table 84 (Check figure Sophia Payne's Ontario rev id equal $ 153.580) Background: accounting format, zero decimal places (Windows | Mac). Change the column and row labels to a. What is the revenue ge erated by each sales rep? How much revenue did Franklin better reflect the data. (General Ledger Accounts, Gross Profit, Total ) Make each worksheet Smithers generate? by Corporation manufactures a variety of indoor and outdoor furniture, It has several ab a different color. manufacturing facilities located in the different states or provinces: Ontario and British b. Which sales rep generates the most reve serates the least? Columbia in Canada, and Kansai, North Carolina, Ohin, and Texasin the United States. Each Pivot table #1 (Check figure: Cell B7 should be $ (429,680)) . How much of each sales rep's revenue is generated from facilities in Canada? From manufacturing facility makes its cwm unique products. The compa any uses just-in-time inventory Create a phut table to answer the following questions. Type your answers into the questions in facilities in the United States? Hint: Use a filter in the pivot table (Windows | Mac]. management, so it has no signific atory twy has Ore sales representatives who can sell Connect. [Not all questions are in Connect but your pivot table should answer all of them.) conducts from any of its manufacturing How much revenue did Hallie Ving generate in Canada? B. What is the total revenue? recent month have been exported to an d. How much of each sales rep's reven erated by each of the facilities within All transactions in tory's job cost systems for the mo b. What is the total direct material used? Excel file that can be downloaded at http://tiny ce/hvydata In this transaction file, revenue each country? Hint: Use a filter in the plant table (Windows | Mac) nts are shown as positive numbers while all costs shown as engative numbers. The e What is the total direct labor used? How much of Sophie Payne's revenue was generated in Kansas? transactions file contains the following Welds d. What is the total manufactu verhead applied? Customer What is the total gross profit? Grading Rubric 2. Pirot table #2 (Check figure: G/1 8450) - Mig. overhead should be $ (74,461) for the Four pivot tables were created with the . Sales rep Ontario facility) Pivot table numbers correctly format Pivot table columns and rows labeled What is the total revenue, total direct material total direct labor total manu Worksheet has live differe overhead, and total grom profit? Correct answers to questions in Cen (12 Amount .for each country? Total oh costs in bey's system are tracked using four diffe eral led mbers: GAL #13100 Revenue; G/1 14101 -Direct material G/1 84303 - Direct labor and O/I WASOL- b. los each state or prov mufacturing overhead. c. Which manufacturing facility bas the most gross profit? Which has the least? Bets that in this came, gross profit ish are are no li This case as adapted from one by De. Wendy Diet d. Which country's ma turing facilities generate the most gross profit