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

 If possible may I please have help answering the multiple choicequestions? I will make sure to upvote help. Thank you DR-580 Diving

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

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!