Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur? to units (b) Use Goal Seek to find the exact breakeven point. Assign Set cell: equal to the location of profit, To value: 0, and By changing cell: equal to the location of the production volume in your model. units

What can the weighted average contribution margin ratio be used for?   Multiple Choice To solve for a measure, at any level of sales volume, of the sensitivity of operating profit to changes in volume. Breakeven and profit planning for sales volume expressed in dollars (Y) rather than units (Q). To calculate an average per-unit contribution margin based on an assumed sales mix. To figure out the relative proportion in which a company’s products (or services) are sold. To determine the extent of fixed costs in an organization’s cost structure.

help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

1. Fill in the missing numbers in the table. Use the following questions to help fill in the missing numbers in the​ table:   a. What is the total contribution​ margin? b. What is the total variable​ expense? c. How many units were​ sold? d. What is the​ per-unit variable​ expense? e. What is the​ per-unit contribution​ margin? 2. Answer the following questions about breakeven​ analysis:   a. What is the breakeven point in​ units? b. What is the breakeven point in sales​ dollars? 3. Answer the following questions about target profit analysis and safety​ margin:   a. How many units must the company sell in order to earn a profit of $48,000​? b. What is the current margin of safety in​ units? c. What is the margin of safety in sales​ dollars? d. What is the margin of safety in​ percentage?