variable cost

variable cost & contribution margin

e steps y 1) Downlo 2) Click o 3) Perform 4) Check 5) Use yo Cesources A) Informi B) If you C) Trouble 1 2 Help He 3 4 5 6 BP-100 FC-900 8 FM-991 9 FL-030 FL-060 10 This project 11 FL-120 assistance f Using the E 13 12 7 Model # 32855EGRERE DR-580 BB-329 FR-250 FR-760 14 A. $33 B. $45 C. 55 D. $500 19 15 26 17 18 20 21 22 B Type Diving ring set, 10 pack Beach balls, 50-pack Foam rafts, regular, 20-pack Foam rafts, premium, 10-pack Baby pool toys variety 6-pack Floating cup holders, 50-pack Foam noodle, variety. 50-pack Inflatable small floats, 20-pack Inflatable medium floats, 10-pack Inflatable large floats, 5-pack D C Quantity Price per unit 288***8** 150 100 100 75 75 150 75 100 75 75 $22 $3,300 $50 $5,000 $50 $5,000 $55 $40 $37 $35 560 E Total Reveque $50 $40 $4,125 $3,000 $5.550 $2.625 $6,000 $3,750 $3,000 G H F Variable cost Contribution Total per pack margin per contribution pack margin ta file ck of n Check Figures R1 - Cell F2 R2-Cell G2 R3-Cell H2 Print $10 $12 $1,800 Done - X match, do not proc Using the Excel file you created for Ripple, what is the variable cost per pack of model BB-329? OA. $33 OB. $45 OC. $5 D. $500 Using the Excel file you created for Ripple, what is the contribution margin per pack of model FR-760? OA. $5 OB. $375 OC. $17 OD. $50 Using the Excel file you created for Ripple, what is the total contribution margin of model FL-060? OA. $12 OB. $38 C. $900 OD. $2,000 Using the Excel file you created for Ripple, what is the total contribution margin for the special order? OA. $(75) O B. $12,225 OC. $(1) OD. $41,350 Using the Excel file you created for Ripple, should the company accept this special order? Explain A. No. The fixed manufacturing overhead (MOH) per unit has not been included in the analysis B. No. The total contribution margin is less than the total revenue, so the project should be rejes OC. Yes. The total contribution margin is positive, so the project should be accepted. OD. Yes. The variable cost per pack for each model is positive, so the project should be accepted Ripple Pool Toys Corporation manufactures a variety of pool toys. Ripple has just received a special order for a large volume of pool toys at reduced special order prices. The data file contains an Excel worksheet of the special order named SpecialOrder. There is a second worksheet that contains Ripple's job cost records from the most recent month named JobCostRecords. The list is sorted chronologically with the most recent orders first. This JobCostRecords worksheet contains 445 job cost records. Requirements for the Excel analysis 1. Use the VLOOKUP function in Cells F2 through F11 in the SpecialOrder worksheet to look up the most recent variable cost for each item in the JobCostRecords worksheet. 2. Enter the formula to calculate contribution margin per pack in Cells G2 through G11 in the SpecialOrder worksheet. 3. Calculate the total contribution margin from the special order in Cell H12 in the SpecialOrder worksheet. 4. Should the company accept this special order? Explain your answer. e steps y 1) Downlo 2) Click o 3) Perform 4) Check 5) Use yo Cesources A) Informi B) If you C) Trouble 1 2 Help He 3 4 5 6 BP-100 FC-900 8 FM-991 9 FL-030 FL-060 10 This project 11 FL-120 assistance f Using the E 13 12 7 Model # 32855EGRERE DR-580 BB-329 FR-250 FR-760 14 A. $33 B. $45 C. 55 D. $500 19 15 26 17 18 20 21 22 B Type Diving ring set, 10 pack Beach balls, 50-pack Foam rafts, regular, 20-pack Foam rafts, premium, 10-pack Baby pool toys variety 6-pack Floating cup holders, 50-pack Foam noodle, variety. 50-pack Inflatable small floats, 20-pack Inflatable medium floats, 10-pack Inflatable large floats, 5-pack D C Quantity Price per unit 288***8** 150 100 100 75 75 150 75 100 75 75 $22 $3,300 $50 $5,000 $50 $5,000 $55 $40 $37 $35 560 E Total Reveque $50 $40 $4,125 $3,000 $5.550 $2.625 $6,000 $3,750 $3,000 G H F Variable cost Contribution Total per pack margin per contribution pack margin ta file ck of n Check Figures R1 - Cell F2 R2-Cell G2 R3-Cell H2 Print $10 $12 $1,800 Done - X match, do not proc Using the Excel file you created for Ripple, what is the variable cost per pack of model BB-329? OA. $33 OB. $45 OC. $5 D. $500 Using the Excel file you created for Ripple, what is the contribution margin per pack of model FR-760? OA. $5 OB. $375 OC. $17 OD. $50 Using the Excel file you created for Ripple, what is the total contribution margin of model FL-060? OA. $12 OB. $38 C. $900 OD. $2,000 Using the Excel file you created for Ripple, what is the total contribution margin for the special order? OA. $(75) O B. $12,225 OC. $(1) OD. $41,350 Using the Excel file you created for Ripple, should the company accept this special order? Explain A. No. The fixed manufacturing overhead (MOH) per unit has not been included in the analysis B. No. The total contribution margin is less than the total revenue, so the project should be rejes OC. Yes. The total contribution margin is positive, so the project should be accepted. OD. Yes. The variable cost per pack for each model is positive, so the project should be accepted Ripple Pool Toys Corporation manufactures a variety of pool toys. Ripple has just received a special order for a large volume of pool toys at reduced special order prices. The data file contains an Excel worksheet of the special order named SpecialOrder. There is a second worksheet that contains Ripple's job cost records from the most recent month named JobCostRecords. The list is sorted chronologically with the most recent orders first. This JobCostRecords worksheet contains 445 job cost records. Requirements for the Excel analysis 1. Use the VLOOKUP function in Cells F2 through F11 in the SpecialOrder worksheet to look up the most recent variable cost for each item in the JobCostRecords worksheet. 2. Enter the formula to calculate contribution margin per pack in Cells G2 through G11 in the SpecialOrder worksheet. 3. Calculate the total contribution margin from the special order in Cell H12 in the SpecialOrder worksheet. 4. Should the company accept this special order? Explain your