80.2K

Verified Solution

Link Copied!

The steps you will follow for this project are as follows:

Download the Excel data file.

Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step$-$

by$-$step.

Perform the requirements on the data file.

Check your work in the Excel file with these check figures.

Use your Excel file to answer the five multiple choice questions below. $($You will have to scroll down to see all of the questions.$)$

Resources

A$)$ Information on how to update Excel and Office $365.$

B$)$ If you do not have Office $365,$ click here to learn how to get it for free.

C$)$ Troubleshooting FAQ.

This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not

proceed with answering the questions until you have asked for assistance from your instructor.

Using the Excel file you created for Floaters, what is the variable cost per pack of model BB$-329?$

A$.$ $$440$

B$.$ $$4$

C$.$ $$37$

D$.$ $$49$

Using the Excel file you created for Floaters, what is the contribution margin per pack of model FR$-760?$

A$.$ $$340$

B$.$ $$4$

C$.$ $$54$

D$.$ $$16$

Using the Excel file you created for Floaters, what is the total contribution margin of model FL$-060?$

A$.$ $$11$

B$.$ $$2,090$

C$.$ $$935$

D$.$ $$42$The steps you will follow for this project are as follows:

Download the Excel data file.

Click on the Video button on the bottom left or within the Get More Help menu for this question now. This tutorial video will walk you through this exercise, step$-$

by$-$step.

Perform the requirements on the data file.

Check your work in the Excel file with these check figures.

Use your Excel file to answer the five multiple choice questions below. $($You will have to scroll down to see all of the questions.$)$

Resources

A$)$ Information on how to update Excel and Office $365.$

B$)$ If you do not have Office $365,$ click here to learn how to get it for free.

C$)$ Troubleshooting FAQ.

This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not

proceed with answering the questions until you have asked for assistance from your instructor.

Using the Excel file you created for Floaters, what is the variable cost per pack of model BB$-329?$

A$.$ $$440$

B$.$ $$4$

C$.$ $$37$

D$.$ $$49$

Using the Excel file you created for Floaters, what is the contribution margin per pack of model FR$-760?$

A$.$ $$340$

B$.$ $$4$

C$.$ $$54$

D$.$ $$16$

Using the Excel file you created for Floaters, what is the total contribution margin of model FL$-060?$

A$.$ $$11$

B$.$ $$2,090$

C$.$ $$935$

D$.$ $$42$

Using the Excel file you created for Floaters, what is the total contribution margin for the special order?

A$.$ $$(170)$

B$.$ $$48,965$

C$.$ $$(2)$

D$.$ $$12,075$

Using the Excel file you created for Floaters, 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$.$ 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.

C$.$ Yes. The total contribution margin is positive, so the project should be accepted.

D$.$ Yes. The variable cost per pack for each model is positive, so the project should be accepted.

Using the Excel file you created for Floaters, what is the total contribution margin for the special order?

A$.$ $$(170)$

B$.$ $$48,965$

C$.$ $$(2)$

D$.$ $$12,075$

Using the Excel file you created for Floaters, 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$.$ 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.

C$.$ Yes. The total contribution margin is positive, so the project should

Answer & Explanation Solved by verified expert

See Answer