In this assignment you will first complete the problem by hand $($part A$)$ and then automate the work $($Part B$)$ on a spreadsheet. Please read the scenario below before proceeding to part $A.$

Scenario: Doll Crafters is planning to manufacture dolls under its own brand name. You are tasked to investigate the production of such dolls. Upon examining the costs associated with production, you find the cost to make one doll $($material and labor$)$ is $$15.$ There is an associated fixed cost that must be paid for $($renting factory space$)$ in the sum of $$2000.$

Part A$.$ Please calculate by hand:

Doll Crafters' marketing folks have suggested setting the selling price of a doll at $$30.$

At this price how many dolls would the company have to sell to break even?

What would the total revenue be at this break$-$even point?

You convinced the CEO of Doll Crafters to raise the selling price of each doll to $$40($same material and labor cost$).$

$3.$ Given this new price how many dolls would the company have to sell to break even?

$4.$ What would the total revenue be at this break$-$even point?

Grading$/$evaluation of Part $A$ is based on the following rubric:

Correct formulas$/$methods used $($I need to see the formulas that you use$)$

Correct values extracted from the scenario.

Correct process of computation.

Explanation of result$($s$)$

Part B$.$ Being a smart business analyst, you figure you could automate the analyses on a spreadsheet. Set up Doll Crafters problem on a spreadsheet format $($see how you should set up your spreadsheets for automation: Sample structure of a spreadsheet for a different problem type $).$ Have your spreadsheet set up so the input cells $($prices$,$ cost$/$unit and associated fix costs$)$ can be changed. Have the spreadsheet then provide answers automatically to