2-3 using EXCEL please

Instructions: Work the following problems in Excel. For each problem, develop your own spreadsheet model to solve the problem or adapt one you already have. Requirements: Your submission should be a single Excel workbook with each of the problems solved on a separate worksheet/tab. Please label the tabs with the problem numbers and order them in the same order as the problems. Include an appropriate title (e.g., "Problem 1: Productivity of Cookie Operation") and your name on each worksheet. A template has been provided. Solutions should be logically structured, properly labeled, and should "stand alone" as solutions to the problem. Your do not have to create "general purpose" models, just solve the problem as written. However, all numerical solutions must be calculated using formulas (don't just type in the answers). File naming: Please name your file using the format Firstname Lastname Assignment 1.xlsx, where Firstname is your first name and Lastname is your last name. Problems (points as indicated! 1. A cookie company employs eight (8) production workers baking and packaging a certain line of cookies. In a full eight-hour day, they produce 1440 pounds of finished cookies using $850 worth of materials. With benefits, the workers are paid an average of $19.00 per hour. a. Compute the labor productivity in pounds of cookies per man-hour. [2 points) b. Compute the two-factor (labor + materials) productivity in pounds per dollar. [2 points) 2. A new copier company plans to produce one model of copier. The copiers will sell for $820 each. The annual fixed costs of operation are $5,600,000 and the variable cost is $210 per unit. a. Assuming that they can sell everything they produce at this price, compute the breakeven quantity QBEP. (2 points) b. If the company actually produces 11.000 coplers the first year, what will the profit/loss be? [2 points) c Include a fully-labeled breakeven chart illustrating the problem. (2 points] 3. Fixed and variable cost for three potential facility locations are as shown below. Fixed cost Variable cost Location per year per unit A $240,000 $15 B $100,000 $30 $150,000 $20 a. Plot the total cost lines for these four locations on a single cost-volume graph. [2 points) b. If expected output is to be 12,000 units per year, which location would provide the lowest cost? [2 points) c. Identify the range of output over which each location alternative would be preferred (lowest cost). Compute the relevant crossover point(3), and clearly indicate your conclusion. [2 points)