Preview File Edit View Go Tools Window Help 19% (4) Mon 3:14 PM a b phpxxi3 Go.png Q Search Calculate revisions on 3rd tab and rename the Sheet1 tab 1. Calculate the total price revisions for both Breeland and Josh and the impact on Ace's bottom line. 2. Always use cell references and formulas and formatting ( $.) where appropriate to receive full credit Check figures: Breeland Josh $1,256,400 $57,600 See REQUIRED QUESTIONS #4 in case; reprinted here: if Abby were to modify her original cost estimate of the Breeland order, and Josh's purchase of the 10 unused gallons, what price determination would she have arrived at? What impact would that have on Ace Fertilizer's bottom line? i.e. compare the revised quotes (tab 1) to the new prices, show what happens to profits Use your calculations to talk with your group about the impact on Ace's bottom line if you were to submit the new price quotes to both Bretland and Josh Data you will need for your calculations: Costs and Activities: 50 gallon drum XO-1600 price per gallon disposal 10 gallons unused XO-1600 DM in addition to XO-1600 DL Unit measure of special order, in gallons Number of batches for production $80,000 $1,600 $10,000 $20,000 $30,000 4,000 4 ABC costs: MAY 25 W D E H J L K M - N 0 P Q R S T U Josh Original Breeland Original $20,000 $80,000 $10,000 Breeland Revised $20,000 $80,000 $10,000 $16,000 $30,000 $30,000 $160,000 $20,000 $80,000 $30,000 $320,000 $160,000 $20,000 $80,000 $30,000 $320,000 $750,000 $900,000 $750,000 $600,000 $16,000 $12,800 $1,650,000 $1,350,000 $28,800 B C Price Quote - Breeland Ltd. (and George's brother Josh) 2 3 Direct Materials Non-X0-1600 4 XO-1600 purchase cost 5 Disposal Cost 6 7 Direct Labor 8 9 Activity level Unit 10 Batch 11 Product 12 Customer 13 Organization sustaining 14 15 total costs 16 mark up cost 17 18 Total Price Determination for Breeland Ltd Order; and Josh 10 gallons 19 20 21 Costs and Activities: 22 50 gallon drum XO-1600 $80,000 price per gallon: 23 disposal 10 gallons unused XO-1600 $10,000 24 DM in addition to XO-1600 $20,000 25 DL $30,000 26 Unit measure of special order, in gallons 4,000 27 Number of batches for production 4 28 ABC costs: 29 Unit-level $40 per unit 30 Batch-level $5,000 per batch 31 Product-Level $80,000 per project 32 Customer Related $30,000 per customer 33 Organization Sustaining DM, DL, unit, batch 100% 34 Per Tom Brennen, special orders must be billed at 80% over the cost of the order 35 36 37 38 $1,600 Abby divided the $750,000 by 80% instead of multiplying by 80% Breeland revised Josh original instructions Sheet1 + ASSIGNMENT INFORMATION Points Possible Due Date Sunday, May 31, 2020 11:59 PM 10 Use the file ACE FERTILIZER case for the data Create a new tab and label it Revised Quote Complete revised quotes per Required Questio #4 in the se: If Abby were modify original estimate of Breeland Ltd special order to include Josh's purchase of the remaining 10 gallons of XO-1600, what price determination would she have arrived at? On this same tab, complete the new price quote for Josh, side by side with Breeland. Check figures are included in the "instructions" tab; submission must be via cell references and formulas to receive full credit Rename the Excel file: with your last name, date submitted, and Ace Fertilizer. e.g. Rose May31 Ace Fertilizer upload via BB ACE FERTILIZER case.xlsxE When finished, make sure to click Submit. Optionally, click Save as Draft to save changes and continue working later, or click Cancel to quit without saving changes. Cancel Save Draft Submit Preview File Edit View Go Tools Window Help 19% (4) Mon 3:14 PM a b phpxxi3 Go.png Q Search Calculate revisions on 3rd tab and rename the Sheet1 tab 1. Calculate the total price revisions for both Breeland and Josh and the impact on Ace's bottom line. 2. Always use cell references and formulas and formatting ( $.) where appropriate to receive full credit Check figures: Breeland Josh $1,256,400 $57,600 See REQUIRED QUESTIONS #4 in case; reprinted here: if Abby were to modify her original cost estimate of the Breeland order, and Josh's purchase of the 10 unused gallons, what price determination would she have arrived at? What impact would that have on Ace Fertilizer's bottom line? i.e. compare the revised quotes (tab 1) to the new prices, show what happens to profits Use your calculations to talk with your group about the impact on Ace's bottom line if you were to submit the new price quotes to both Bretland and Josh Data you will need for your calculations: Costs and Activities: 50 gallon drum XO-1600 price per gallon disposal 10 gallons unused XO-1600 DM in addition to XO-1600 DL Unit measure of special order, in gallons Number of batches for production $80,000 $1,600 $10,000 $20,000 $30,000 4,000 4 ABC costs: MAY 25 W D E H J L K M - N 0 P Q R S T U Josh Original Breeland Original $20,000 $80,000 $10,000 Breeland Revised $20,000 $80,000 $10,000 $16,000 $30,000 $30,000 $160,000 $20,000 $80,000 $30,000 $320,000 $160,000 $20,000 $80,000 $30,000 $320,000 $750,000 $900,000 $750,000 $600,000 $16,000 $12,800 $1,650,000 $1,350,000 $28,800 B C Price Quote - Breeland Ltd. (and George's brother Josh) 2 3 Direct Materials Non-X0-1600 4 XO-1600 purchase cost 5 Disposal Cost 6 7 Direct Labor 8 9 Activity level Unit 10 Batch 11 Product 12 Customer 13 Organization sustaining 14 15 total costs 16 mark up cost 17 18 Total Price Determination for Breeland Ltd Order; and Josh 10 gallons 19 20 21 Costs and Activities: 22 50 gallon drum XO-1600 $80,000 price per gallon: 23 disposal 10 gallons unused XO-1600 $10,000 24 DM in addition to XO-1600 $20,000 25 DL $30,000 26 Unit measure of special order, in gallons 4,000 27 Number of batches for production 4 28 ABC costs: 29 Unit-level $40 per unit 30 Batch-level $5,000 per batch 31 Product-Level $80,000 per project 32 Customer Related $30,000 per customer 33 Organization Sustaining DM, DL, unit, batch 100% 34 Per Tom Brennen, special orders must be billed at 80% over the cost of the order 35 36 37 38 $1,600 Abby divided the $750,000 by 80% instead of multiplying by 80% Breeland revised Josh original instructions Sheet1 + ASSIGNMENT INFORMATION Points Possible Due Date Sunday, May 31, 2020 11:59 PM 10 Use the file ACE FERTILIZER case for the data Create a new tab and label it Revised Quote Complete revised quotes per Required Questio #4 in the se: If Abby were modify original estimate of Breeland Ltd special order to include Josh's purchase of the remaining 10 gallons of XO-1600, what price determination would she have arrived at? On this same tab, complete the new price quote for Josh, side by side with Breeland. Check figures are included in the "instructions" tab; submission must be via cell references and formulas to receive full credit Rename the Excel file: with your last name, date submitted, and Ace Fertilizer. e.g. Rose May31 Ace Fertilizer upload via BB ACE FERTILIZER case.xlsxE When finished, make sure to click Submit. Optionally, click Save as Draft to save changes and continue working later, or click Cancel to quit without saving changes. Cancel Save Draft Submit