Question: If possible may I please have help answering the multiple choice questions? I will make sure to upvote help. Thank you DR-580 Diving ring set,
If possible may I please have help answering the multiple choice questions? I will make sure to upvote help. Thank you


| DR-580 | Diving ring set, 10-pack | 150 | $ 22 | $ 3,300 |
| BB-329 | Beach balls, 50-pack | 100 | $ 50 | $ 5,000 |
| FR-250 | Foam rafts, regular, 20-pack | 100 | $ 50 | $ 5,000 |
| FR-760 | Foam rafts, premium, 10-pack | 75 | $ 55 | $ 4,125 |
| BP-100 | Baby pool toys, variety 6-pack | 75 | $ 40 | $ 3,000 |
| FC-900 | Floating cup holders, 50-pack | 150 | $ 37 | $ 5,550 |
| FM-991 | Foam noodle, variety, 50-pack | 75 | $ 35 | $ 2,625 |
| FL-030 | Inflatable small floats, 20-pack | 100 | $ 60 | $ 6,000 |
| FL-060 | Inflatable medium floats, 10-pack | 75 | $ 50 | $ 3,750 |
| FL-120 | Inflatable large floats, 5-pack | 75 | $ 40 | $ 3,000 |
| $ 41,350 |
your instructor. Using the Excel file you created for Ripple, what is the variable cost per pack of model BB-329? A. $500 B. $45 C. $33 Using the Excel file you created for Ripple, what is the contribution margin per pack of model FR-760? A. $5 B. $375 C. $50 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. Using the Excel file you created for Ripple, what is the total contribution margin of model FL-060? A. $900 B. $2,000 C. $12 Using the Excel file you created for Ripple, what is the total contribution margin for the special order? A. $12,225 B. $(75) C. $(1) D. $41,350 Using the Excel file you created for Ripple, should the company accept this special order? Explain. A. No. The total contribution margin is less than the total revenue, so the project should be rejected. B. Yes. The total contribution margin is positive, so the project should be accepted. C. Yes. The variable cost per pack for each model is positive, so the project should be accepted. D. No. The fixed manufacturing overhead (MOH) per unit has not been included in the analysis. Fixed MOH needs to be included to determine if the project should be accepted. your instructor. Using the Excel file you created for Ripple, what is the variable cost per pack of model BB-329? A. $500 B. $45 C. $33 Using the Excel file you created for Ripple, what is the contribution margin per pack of model FR-760? A. $5 B. $375 C. $50 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. Using the Excel file you created for Ripple, what is the total contribution margin of model FL-060? A. $900 B. $2,000 C. $12 Using the Excel file you created for Ripple, what is the total contribution margin for the special order? A. $12,225 B. $(75) C. $(1) D. $41,350 Using the Excel file you created for Ripple, should the company accept this special order? Explain. A. No. The total contribution margin is less than the total revenue, so the project should be rejected. B. Yes. The total contribution margin is positive, so the project should be accepted. C. Yes. The variable cost per pack for each model is positive, so the project should be accepted. D. No. The fixed manufacturing overhead (MOH) per unit has not been included in the analysis. Fixed MOH needs to be included to determine if the project should be accepted
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
