Question: fFile Edit View Insert Format Data Tools Help 75% $ % .00 123 Defaul - 10 + BI - A1 fx B C D E

\fFile Edit View Insert Format Data Tools Help 75% $ % .00 123 Defaul - 10 + BI - A1 fx B C D E G H J K L M N O P Q R A Date Item Predicted Price Actual Price 1/31/2024 Facility Rent 6,000.00 6000 1/31/2024 Utilities 3, 811.08 3900 1/31/2024 Security 1,000.00 1000 1/31/2024 Other Indirect Costs 12,000.00 12000 1/31/2024 Janitorial Supplies 3,400.00 3500 2/28/2024 Facility Rent 6,250.00 6275 2/28/2024 Utilities 2, 658.13 3000 2/28/2024 Security 1,000.00 1000 2/28/2024 Other Indirect Costs 11,500.00 11750 2/28/2024 Janitorial Supplies 3,200.00 3250 21 22 23 24 25 26 27 29 30 32 33 34 35 37 38 + E Rollup - Calculations . Info . Materials Reas . Input Purchases Time sheets _ Indirect Costs . Codebook > +rollup project 2 -SP23 - clean (1) .XLSX & Share File Edit View Insert Format Data Tools Help 100% $ % .0 .00 123 Defaul - 10 + B I A A1 fx A B C D E F G H I J K L M N Date Item Units Price per Unit W N 1/1/2024 NV_001 20,000 $ 0.8800 1/1/2024 INV_002 55,000 $ 0.3300 1/1/2024 INV_003 12,500 0.0250 1/1/2024 INV 004 22,000 0.1000 1/8/2024 INV 001 5,000 0.8800 1/8/2024 INV_002 6,000 0.3300 1/8/2024 INV_003 5,000 0.0240 10 1/8/2024 INV_004 12,000 0.1000 1/15/2024 INV 001 41,000 0.8900 12 1/15/2024 INV_002 36,000 0.3400 13 1/15/2024 INV_003 5,000 0.0270 14 1/15/2024 INV_004 20,000 0.1100 15 1/22/2024 INV 001 7,000 0.1000 1/22/2024 NV 002 12,000 0.8900 1/22/2024 INV_003 4,000 0.3400 18 1/22/2024 INV_004 10,000 0.0270 19 2/1/2024 INV_001 30,000 0.1100 20 2/1/2024 INV_002 45,000 0.3400 21 2/1/2024 INV_003 4,500 $ 0.0300 22 2/1/2024 INV_004 10,000 0.1100 23 2/13/2024 INV_001 5,000 0.9000 24 2/13/2024 INV_002 55,000 0.3400 25 2/13/2024 INV 003 5,500 0.0300 26 2/13/2024 INV_004 19,500 S 0.1100 27 28 29 30 31 32 33 34 + Rollup - Calculations . Info . Materials Reas . Input Purchases Time sheets ~ Indirect Costs - Codebook + +A1 '3 c' IE! '1? 100% v 3 % IL 112 123 Defaul... v Per Unit Information, predicted Finished Good DI. Hours Cream Cheese Cherries 0702 008 12 5 D_03 0,07 0 19 Per Batch Information, predicted + 1 Finished Good Machine Setups cleanups Material Moves D702 4 6 4 0,03 7 5 3 Project Background Information: Flour Eggs 5,5 Predicted Actual Cakes per Month Cakes per Month 3,300 3,235 4,500 4,520 Final corporation is in the business of producing fancy desserts. Final sells these desserts to retailers. These are produced from raw material inputs. Information related to the operations are provided in the table. Predicted and Actual Per Batch Information are the same. Two batches are produced each month for both products. All Labor is paid Social Security at 6.2% and Medicaid at 1.45%. All employees' wages are subject to these amounts. Employees did not earn overtime. Employees are expected to work 45% on Cakes and 55% of their time on pies. The company begins January with no WIP or Raw Materials for the inventory items. All input inventory is used FIFO. Fixed Equipment is depreciated using the Straight Line method over 20 years. None of the equipment is fully depreciated during the period, Rollup v Calculations v Info v Materials Rum Indirect Costs v Codebook ) S 5 75% $ % .0 .00 123 Defaul 10 + B fx B C D E F G H I J K L M N P Q R S Time Sheet ID TS_33241 Time Sheet ID TS_33242 Time Sheet ID TS_33243 Time Sheet ID TS_33244 Employee ID B_001 Employee ID E_001 Employee ID E 002 Employee ID E_003 Employee Name A. Alexander Employee Name B. Bradley Employee Name C. Christiansen Employee Name D. Duvall Date Hours Worked Desert Line Date Hours Worked Desert Line Date Hours Worked Desert Line Date Hours Worked Desert Line /1/2024 8 D_OZ 1/1/2024 3 D_02 1/1/202 D_02 1/1/2024 8 D_02 1/2/2024 8 D_02 1/2/2024 8 D_02 1/2/2024 8 D_02 1/2/2024 8 D_02 1/3/2024 8 D_02 1/3/2024 8 D 02 1/3/2024 8 D 03 1/3/2024 8 D_02 1/4/2024 8 D_02 1/4/2024 8 D_02 1/4/2024 8 D_03 1/4/2024 8 D 02 1/5/2024 8 D_02 1/5/2024 8 D_03 1/5/2024 8 D_03 1/5/2024 8 D_03 1/8/2024 8 D_03 /8/2024 8 D 03 1/8/2024 8 D 03 1/8/2024 8 D_03 1/9/2024 8 D_03 1/9/2024 8 D_03 1/9/2024 8 D_03 1/9/2024 8 D 03 1/10/2024 8 D_03 1/10/2024 8 D_03 1/10/2024 8 D_03 1/10/2024 8 D_03 1/11/2024 8 D 03 1/11/2024 8 D_03 1/11/2024 8 D 03 1/11/2024 8 D_03 16 1/12/202 8 D_03 1/12/2024 8 D_03 1/12/2024 8 D_03 1/12/2024 8 D_03 1/15/2024 8 D_02 1/15/2024 8 D_02 1/15/2024 8 D_02 1/15/2024 8 D_02 1/16/2024 8 D_02 1/16/2024 8 D 02 1/16/2024 8 D_02 1/16/2024 8 D_02 1/17/2024 8 D_02 1/17/2024 8 D_02 1/17/2024 8 D_02 1/17/2024 8 D_02 1/18/2024 8 D_02 1/18/2024 D_02 1/18/2024 8 D_02 1/18/2024 B D_02 21 1/19/2024 8 D_02 1/19/2024 8 D_03 1/19/2024 8 D_03 1/19/2024 8 D_03 22 1/22/2024 8 D_03 1/22/2024 8 D 03 1/22/2024 8 D 03 1/22/2024 8 D 03 1/23/2024 8 D_03 1/23/2024 8 D_03 1/23/2024 8 D_03 1/23/2024 8 D_03 1/24/2024 8 D_03 1/24/2024 8 D_03 1/24/2024 8 D_03 1/24/2024 8 D_03 25 1/25/2024 8 D_03 1/25/2024 8 D_03 1/25/2024 8 D_03 1/25/2024 8 D_03 1/26/2024 8 D_03 1/26/2024 8 D 03 1/26/2024 8 D 03 1/26/2024 8 D_03 27 1/29/2024 8 D_02 1/29/2024 8 D_02 1/29/2024 8 D_02 /29/202 8 D_02 1/30/2024 8 D_02 1/30/2024 8 D_02 1/30/2024 8 D_02 1/30/2024 8 D 02 1/31/2024 8 D_02 1/31/2024 8 D 02 1/31/2024 8 D_02 /31/2024 8 D_02 30 32 Time Sheet ID TS_33245 Time Sheet ID TS_33246 Time Sheet ID TS_33247 Time Sheet ID TS_33248 Employee ID B_001 Employee ID E_001 Employee ID E_002 Employee ID E_003 34 Employee Name A. Alexander Employee Name B. Bradley Employee Name C. Christiansen Employee Name D. Duvall Date Hours Worked Desert Line Date Hours Worked Desert Line Date Hours Worked Desert Line Date Hours Worked Desert Line 2/1/2024 8 D_02 2/1/2024 8 D_02 2/1/2024 8 D 03 2/1/2024 B D_03 2/2/2024 8 D_02 2/2/2024 8 D_02 2/2/2024 B D_03 2/2/2024 8 D_03 38 2/5/2024 8 D_03 2/5/2024 8 D_03 2/5/2024 8 D 03 2/5/2024 8 D_03 39 2/6/2024 8 D_02 2/6/2024 8 D_03 2/6/2024 B D_03 2/6/2024 3 D_03 40 2/7/2024 8 D_03 2/7/2024 8 D 03 2/7/2024 8 D 03 2/7/2024 8 D_03 2/8/2024 8 D_03 2/8/2024 8 D_03 2/8/2024 8 D_03 2/8/2024 8 D_03 42 2/9/2024 8 D 03 2/9/2024 8 D 03 2/9/2024 8 D_03 2/9/2024 8 D_03 43 2/12/2024 8 D_02 2/12/2024 8 D_02 2/12/2024 8 D_02 2/12/202 8 D_02 44 2/13/2024 8 D_02 2/13/2024 8 D_ 02 2/13/2024 8 D_02 2/13/2024 8 D_02 45 2/14/2024 8 D_02 2/14/2024 8 D 02 2/14/2024 8 D 02 2/14/2024 8 D_02 + Rollup Calculations . Info . Materials Reas Input Purchases Time sheets ~ Indirect Costs Codebook bc'ioo'xv $ % 0902 A B :l, cheesecake + II TOTAL COST per Cheesecake, predicted TOTAL COST per Cheesecake, actual Predicted DL per Cheesecake Actual DL per Cheesecake Predicted DM per Cheesecake Actual DM per Cheesecake Predicted OH per Cheesecake Actual OH per Cheesecake Cherries per Cheesecake, actual Cherries per Cheesecake, predicted Flour per Cheesecake, actual Flour per Cheesecake, predicted Eggs per Cheesecake, actual Eggs per Cheesecake, predicted Cream Cheese per Cheesecake, actual Cream Cheese per Cheesecake, predicted Rollup v Calculations v 123 Dollars Units Info v Defaul... v Pie Dollars TOTAL COST per Pie, predicted TOTAL COST per Pie, actual Predicted DL per Pie Actual DL per Pie Predicted DM per Pie Actual DM per Pie Predicted OH per Pie Actual OH per Pie Units Cherries per Pie, actual Cherries per Pie, predicted Flour per Pie, actual Flour per Pie, predicted Eggs per Pie, actual Eggs per Pie, predicted Cream Cheese per Pie, actual Cream Cheese per Pie, predicted Materials v Project: Rollup 2 For the given products, complete the cost roll up for the two-month period and enter the required amounts in the 'Rollup' tab. All calculations needed to arrive at these results must be shown in the 'Calculations' tab to receive credit, Deliverables: 1i Worked spreadsheet Complete and submit this worksheet file as directed 1-page lsingle spaced) writeup describing: a. The steps taken to make tables in the Calculations tab b. Interpretation ofthe results (actual vs. predicted) for each input category. v Indirect Costs v Codebook

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Assignment 1 - Horizontal and Vertical Analysis Complete the following assignment. Record the responses on the spreadsheet provided. Part A: Horizontal Analysis Item 2015 2014 2013 Net Sales $980 000...

" Assignment 1 - Horizontal and Vertical Analysis Complete the following assignment and submit your work to the dropbox. Record your responses on the spreadsheet provided. Part A: Horizontal Analysis...

I need to make a summary report and total cost per job using the numbers provided. watu 10018 Add-ons Help Last edit was 2 days ago % 0,09 123- Default (Ca... - 11 BISA 100% ES A B C D E G H 1 2 3 4...

i will upvote please help The formula for computing the area of tube in google sheets square tube area File Edit View Insert Format Data Tools Add-ons 100% $ % . .00 123 Default (Ari.. fx A B H H= h...

I need help with figuring out how to do closing entries, link: https://docs.google.com/spreadsheets/d/17-0NZWEBptWznTz5dp7htSvulSlCotmR/edit?usp=sharing&ouid=101603405340393817310&rtpof=true&sd=true...

Im having some trouble with my accounting assignment can someone help me out? .-2021 XLSX Edit View Insert Format Data Tools Help Last edit was yes 10 75% $ % . .00 123- Arial Pre-adjusted balances...

A bookshop hired you as their data scientist and would like you to help them make better business decisions using data. Here is the data file they provided to you. Last week, you explored the data...

Need help finding the total landed costs for all 6 countries below Cost Structure - Year O (1) .XLSX File Edit View Insert Format Data Tools Help Share Last edit was made yesterday at 5:13 PM by...

Assumptions and Rationale Explain all assumptions used in the forecast and your rationale. Include the following details in your response: Explain assumptions for the Prospective Analysis tab...

Loblaw Manufacturing Cash Budget June 2021 to October 2021 April May June 115,000 135,000 172,000 July 142,000 August September October November 121,000 93,000 76,000 81,000 35% 55% 1096 60% 103,200...

Why would subcontractors for a government project want their activities on the critical path? Under what conditions would they try to avoid being on the critical path?

On October 1st 2022, ABC Co. signed a 5-month note payable with principal of $10,000 and an annual interest rate of 12%. What is the interest expense that the company will report on the 2023 (second...

A supplier gives their customer credit terms of 3 / 1 0 , n / 4 5 . The " 3 " represents the

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....