Please note the following requirements for all Microsoft Excel related assignments in this course:
- You must use the templates supplied within this course for all Excel assignments, and they must not be altered in any
other than to enter the information required to complete the assignment.
- You are required to make use of Excel provided equations (addition, subtraction, multiplication etc.) whenever possible,
of manually entering data ( hard coding) into a cell . This will include making use of being able to copy information from a
Using the information about Western Manufacturing Company provided below, complete the following two tabs in this MS Excel Workbook:
– Cost-volume-profit (CVP) Analysis prepared in February 20X1 regarding planned operations for month of March 20X1
– Contribution Margin (Full-Absorption vs. Variable Costing Method) Analysis prepared in April 20X1 for completed month of March 20X1
The background paper, Management Accounting Concepts, provides useful guidance for completing this assignment.
Based on the results of your CVP Analysis (the first tab following this one), summarize your recommendations to management regarding its
contemplated supplemental March 20X1 advertising campaign described below. Limit the length of your response to 100 words.
Based on the results of your Contribution Margin Analysis (the second tab following this one), explain why the reported results using the fullabsorption method and variable costing method differ from each other. (In formulating your response, it may be helpful to review pages 20 22 of the background paper, Management Accounting Concepts , including the illustration on those pages.) Limit the length of your
response to 100 words.
Replace the text in this cell with your response.
Number of units of the company's only product:
Mar. 20X1 Actual
Included in inventory on hand at March 1, 20X1
Manufactured during month ended March 31, 20X1
Sales for month of March 20X1
Budgeted total production and sales for fiscal year ended (FYE) Dec. 31, 20X1
Average selling price
Mar. 20X1 Actual 17M8W1
Variable manufacturing cost...