Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please fill out table !! Please fill out Table completelyif possible !! -Studert-Template 2Ewcel Sign in AutoSave D Psge Layul Tel me what you went
Please fill out table !!
Please fill out Table completelyif possible !!
-Studert-Template 2Ewcel Sign in AutoSave D Psge Layul Tel me what you went to do Fle Review View Share Conments Home Inser Formuas Dels Hep ulm Cut Wiap Tot Calculation 14 Calibri A A Gereal Noutral Normal Bad Good Pate Cay - Farmat Paintr Fil Sort & Find Fter Select Cordit onal Fomat Formatting Table Check Coll ExplanataryInput Linked Call Imart Delte Furmat B U Merge & Center Note A % Clear Cipba Aigrmn NurEST Styles Fent Cels Edting HT TASK 1 PDOHR A D E G H L M N TASK #1 PDOHR 2 HIGH-END LIFTS BUDGETED MOH 3 57,333 Dapraciation on PP&E 4 5 AR,00 Property Taxes 32,777 Uilities 6 65,000 Insurance 117,200 Indirect labor & bencfits S3,140 Indiract materlals 4 L 10 373,450 TOTAI RUDGFTFD MOH 11 12 BUDGETED DIRECT LABOR HOURS 1.890.625 TOTAL BUDGETED COST OF DL (S68,750 x 27.5 units 1 workers x 2 weeks x 40 hours per weak (400 hours par alewator). 14 11,000 IOIAL BUDGETED DL HOURS: 2/5 units x S 171.88 DI$ per hour 15 16 17 PREDETERMINED MOH RATE 18 TOTAL BUDGETED MOH 19 JUIAL BUDGE TED DL HOURS A B D K TASK #2 PROPOSAL Budgeted Cost Info Per Unit Total Cost per Standard Cost Per Unit Increase Unit 10% $ 15% $ 60,500 DM Costs 55,000 $ DL Costs 68,750 79,063 DL Hours 400 15% 460 Budget Summary for Pricing RFP #240A DIRECTIONS: Direct Material Costs E9 is above E10 is above Direct Labor Costs E11 E6 X TASK #2 CELL B20 (this is applied overhead) E12 is the sum of DM, DL and MOH E13 6 x total cost per unit; F13 E13/E14 E14 E13/.60 Manufacturing Overhead Applied Total Cost per Unit Total Cost for Six Units Price: Markup 40% Gross Margin E15 1500 GIVEN IN PROBLEM Freight & Insurance (Selling Expense, period cost) Check E16 $1,553,295 Total Bid TASK #3 JOB COST RECORD ACTUAL JOB-COST RECORD Description Job Number: RFP From Top Quality Builders: A1 Manufacture 6 Elevators for Expected Date of Completion: Condominium Project In St. 10/1 YEAR 3 Bonaventure, NY Number of Units: 6 Direct Material Requisition Number Date Quantity Unit Price Cost 7/16/2018 8/20/2018 101 E13 AND E14 GIVEN IN PROBLEM (ACTUAL COST PER UNIT) Check: F13 $183,000 120 3 Check: F16 $366,000 Totals Direct Labor Time Card Cost Number Hours Date Rate 7/20/18 J3 171.88 D20 THROUGH D29 (GIVEN IN PROBLEM AT 265) 7/27/2018 J4 171.88 Check D31 2650 8/3/2018 A1 171.88 Check F31 $455,468.75 8/10/2018 8/17/2018 8/24/2018 A2 171.88 S A3 171.88 A4 171.88 8/31/2018 A5 171.88 9/7/2018 9/14/2018 9/28/2018 $ 171.88 S1 171.88 S2 171.88 S3 $ Totals 0 TASK #4 VARIANCE ANALYSIS: BUDGET VERSUS ACTUAL Job A1 Budgeted Actual Variance Sales Price Analysis Sales Price TASK # 2 CELL E14/6; D5 GIVEN; CELL E5 = D5 - C5 C5 Product Costs: C7 TASK #2 CELL E4; D7 GIVEN; CELL E7 C7 - D7 Direct Materials C8 TASK #2 CELL E5; D8 TASK #3 CELL F31 /6; CELL E8 C8 - D8 C9 TASK #2 CELL E6 x Task #1 Cell B20; D9 TASK #3 CELL F39/6; CELL E9 C9 D9 Check C10 $155,180 Direct Labor pplied Total Product Costs Gross Profit Check E12 -7.5% Gross Margin % -Studert-Template 2Ewcel Sign in AutoSave D Psge Layul Tel me what you went to do Fle Review View Share Conments Home Inser Formuas Dels Hep ulm Cut Wiap Tot Calculation 14 Calibri A A Gereal Noutral Normal Bad Good Pate Cay - Farmat Paintr Fil Sort & Find Fter Select Cordit onal Fomat Formatting Table Check Coll ExplanataryInput Linked Call Imart Delte Furmat B U Merge & Center Note A % Clear Cipba Aigrmn NurEST Styles Fent Cels Edting HT TASK 1 PDOHR A D E G H L M N TASK #1 PDOHR 2 HIGH-END LIFTS BUDGETED MOH 3 57,333 Dapraciation on PP&E 4 5 AR,00 Property Taxes 32,777 Uilities 6 65,000 Insurance 117,200 Indirect labor & bencfits S3,140 Indiract materlals 4 L 10 373,450 TOTAI RUDGFTFD MOH 11 12 BUDGETED DIRECT LABOR HOURS 1.890.625 TOTAL BUDGETED COST OF DL (S68,750 x 27.5 units 1 workers x 2 weeks x 40 hours per weak (400 hours par alewator). 14 11,000 IOIAL BUDGETED DL HOURS: 2/5 units x S 171.88 DI$ per hour 15 16 17 PREDETERMINED MOH RATE 18 TOTAL BUDGETED MOH 19 JUIAL BUDGE TED DL HOURS A B D K TASK #2 PROPOSAL Budgeted Cost Info Per Unit Total Cost per Standard Cost Per Unit Increase Unit 10% $ 15% $ 60,500 DM Costs 55,000 $ DL Costs 68,750 79,063 DL Hours 400 15% 460 Budget Summary for Pricing RFP #240A DIRECTIONS: Direct Material Costs E9 is above E10 is above Direct Labor Costs E11 E6 X TASK #2 CELL B20 (this is applied overhead) E12 is the sum of DM, DL and MOH E13 6 x total cost per unit; F13 E13/E14 E14 E13/.60 Manufacturing Overhead Applied Total Cost per Unit Total Cost for Six Units Price: Markup 40% Gross Margin E15 1500 GIVEN IN PROBLEM Freight & Insurance (Selling Expense, period cost) Check E16 $1,553,295 Total Bid TASK #3 JOB COST RECORD ACTUAL JOB-COST RECORD Description Job Number: RFP From Top Quality Builders: A1 Manufacture 6 Elevators for Expected Date of Completion: Condominium Project In St. 10/1 YEAR 3 Bonaventure, NY Number of Units: 6 Direct Material Requisition Number Date Quantity Unit Price Cost 7/16/2018 8/20/2018 101 E13 AND E14 GIVEN IN PROBLEM (ACTUAL COST PER UNIT) Check: F13 $183,000 120 3 Check: F16 $366,000 Totals Direct Labor Time Card Cost Number Hours Date Rate 7/20/18 J3 171.88 D20 THROUGH D29 (GIVEN IN PROBLEM AT 265) 7/27/2018 J4 171.88 Check D31 2650 8/3/2018 A1 171.88 Check F31 $455,468.75 8/10/2018 8/17/2018 8/24/2018 A2 171.88 S A3 171.88 A4 171.88 8/31/2018 A5 171.88 9/7/2018 9/14/2018 9/28/2018 $ 171.88 S1 171.88 S2 171.88 S3 $ Totals 0 TASK #4 VARIANCE ANALYSIS: BUDGET VERSUS ACTUAL Job A1 Budgeted Actual Variance Sales Price Analysis Sales Price TASK # 2 CELL E14/6; D5 GIVEN; CELL E5 = D5 - C5 C5 Product Costs: C7 TASK #2 CELL E4; D7 GIVEN; CELL E7 C7 - D7 Direct Materials C8 TASK #2 CELL E5; D8 TASK #3 CELL F31 /6; CELL E8 C8 - D8 C9 TASK #2 CELL E6 x Task #1 Cell B20; D9 TASK #3 CELL F39/6; CELL E9 C9 D9 Check C10 $155,180 Direct Labor pplied Total Product Costs Gross Profit Check E12 -7.5% Gross Margin %Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started