Based on the data presented in the Unit VIII Spreadsheet Template in Excel (CM Breakeven tab): • Calculate the contribution margin (CM) for each of the three products sold at the cookie business. • Calculate the weighted average CM. • Calculate the breakeven point.
Process Costing
Process costing is a sort of operation costing which is employed to determine the value of a product at each process or stage of producing process, applicable where goods produced from a series of continuous operations or procedure.
Job Costing
Job costing is adhesive costs of each and every job involved in the production processes. It is an accounting measure. It is a method which determines the cost of specific jobs, which are performed according to the consumer’s specifications. Job costing is possible only in businesses where the production is done as per the customer’s requirement. For example, some customers order to manufacture furniture as per their needs.
ABC Costing
Cost Accounting is a form of managerial accounting that helps the company in assessing the total variable cost so as to compute the cost of production. Cost accounting is generally used by the management so as to ensure better decision-making. In comparison to financial accounting, cost accounting has to follow a set standard ad can be used flexibly by the management as per their needs. The types of Cost Accounting include – Lean Accounting, Standard Costing, Marginal Costing and Activity Based Costing.
Part 1: Based on the data presented in the Unit VIII Spreadsheet Template in Excel (CM Breakeven tab):
• Calculate the contribution margin (CM) for each of the three products sold at the cookie business.
• Calculate the weighted average CM.
• Calculate the breakeven point.
Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss the results based on your calculations as far as which type of cookie you think is the most profitable, which has the highest CM, etc.
Step by step
Solved in 4 steps
