Question: Download the Excel data file and complete the question below. Prairie Fields Bakery is a bakery specializing in pies. They are exploring options for expanding

Download the Excel data file and complete the question below. Prairie Fields Bakery is a bakery specializing in pies. They are exploring options for expanding their product line by baking and selling cakes. The sale price for each cake will be $15. The following cost information has been provided: You ar a cost accou ant for Prairie Fields Bakery, and you would like to analyze the cost-volume-profit for the proposed cake line. You will present your analysis to management. Your approach is to create a dashboard with the following visuallzations: 1. Contribution Margin per Unit - This is a pie chart showing the contribution margin per unit as a pie slice and the total variable cost per unit as another pie slice. The total sales price per unit is also displayed in the center. 2. Variable Costs per Unit - This is a pie chart showing the direct labor per unit as a pie slice and the direct materlals per unit as another ple slice. The total variable costs per unit is shown in the center: 3. Total Fixed Costs - This is a pie chart showing the administrative, utilities and rent costs as pie slices. The total fixed costs value is shown in the center. 4. Operating Income by Sales Unit - This is a bar chart showing the operating income for sales units from 0 to 1000 (in increments of 100 ). 5. Cost-Volume-Profit Graph - This is a line chart showing the total revenue, total fixed costs, and total costs for sales units from 0 to 1000 (in increments of 100 ). If Prairle Fields Bakery's goal is to have an operating income of $5,000, how many cakes need to be sold? What would be the total revenue and the total costs associated with this sales volume
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
