Use the table below to answer the following question(s). In the spreadsheet below, there is data on the price, cost, demand, and quantity produced for an item. There are also different "what if" values that can help a manager to calculate costs and revenue with variability in demand. JA Profit Model B 2 What-If Demand Values 3 Data |20,000 |40,000 |55,000 60,000 |65,000 4 |Unit Price ($) |Unit Cost ($) Fixed Cost ($) Demand Quantity Produced |50 |25 |550,000 |60,000 |55,000 15 17 19 10 Which of the following is the Excel formula to determine the number of units sold? =B8 =MIN(0,B8,B9) =MAX(0,B8,B9) =MIN(B8,B9)

Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to 12 and changing the objective function coefficient for Product 3 to 18?

To drive more sales of its new LED light bulbs, GreenLED gave customers who sent in the right paperwork, a check for $1 for each light bulb they purchased. This is an example of

can you help me with this, show me how to do on excel plz

Need all please

the price ôf b. What Is the breakeve reduces the amount of particulates emitted into the . c. What other considera 8. Techno Corporation is c variable costs of $5 per turing this item are $14 the item is $10 per unit 30,000 units. ble cost to each casting Spartan produces. The second pro- bas fixed costs of $150,000 and adds $90 of variable cost per casting. What is the break-even quantity beyond which the first a. Techno can substa process is more attractive? What is the difference in total cost if the quantity installing new equ of $60,000. Variab! but, as more of the the annual volum produced is 10,000? Techno buy the n price of the item A A news clipping service is considering modernization. Rather Ahan manually clipping and photocopying articles of inter- est and mailing them to its clients, employees electronically input stories from most widely circulated publications into a database. Each new issue is searched for key words, such as a client's company name, competitors' names,…

Below are the market prices and historical prices that your company has been paying for three different purchasing teams. Which of the purchasing teams is performing the BEST? Steel Paper Fuel a) Steel Ob) Paper PPI (Market) Oct-19 173.7 176.3 166.8 Oct-20 191.7 186.5 187.6 O) Fuel O d) None of the teams are performing well Oe) There is not enough information to make a determination Actual (Historical) Oct-19 2.25 27 132.75 Oct-20 3 28.8 145

Please solve first part with explanation. Wrong answer = downvote

Convert TJX's 2019 and 2018 income statement to component percentages, and analyze vertically. Round percentages to hundredths of a percent. Component Percentages (in thousands) Year Ended 2/2/2019 Year Ended 2/3/2018 Net sales 38,972,934 ? 35,864,664 ? Cost of sales 27,831,177 ? 25,502,167 ? Selling, G&A expenses 6,923,564 ? 6,375,071 ? Impairment of goodwill & other n/a 99,250 ? LTA Pension settlement charge 36,122 ? n/a Interest expense, net 8,860 ? 31,588 ? Income before provision for 4,173,211 ? 3,856,588 ~. ? income taxes Provision for income taxes 1,113,413 ? 1,248,640 ? Income before provision for 3,059,798 ? 2,607,948 ? income taxes

2. Perform an ABC analysis for the data provided. Clearly explain why you classified items as A, B, or C. Annual Unit Item Usage 2400 Cost $19.51 $32.60 $10.20 $6.80 2 6200 3 8500 4 3200 6000 $4.50 $55.70 $3.60 $44.90 $35.62 750 7 8200 8 9000 5800 10 820 $82.60 $40.50 11 500 12 2000 $15.40 $14.60 $35.80 13 2400 14 6300 15 4750 $17.30 2700 $51.75 $42.90 $25.30 16 17 1600 18 1350 19 5000 $67.00 20 1000 $125.00