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

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

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!