I need to do the quantivity analysis, like in the excel, but I feel in trouble, could anyone can help me

Pickleroach Inc. (PR) manufactures pet clothes. The company specializes in camouflage plastic ponchos to protect dogs from predators on trails across Canada. The company currently has demand for 250,000 ponchos per year. The CEO, Marc Daron, calls you to his office and asks for your help with addressing immediate issues facing the company; namely, expanding sales to the US and a special order from a large distributor named Wobblyball (WB). You are asked to consult your team and prepare a report to Marc with your analysis and any possible considerations that PR should keep in mind. Expanding to US #"XD Marc lets you know that there has been some interest from buyers in the United States and the company may be able to sell an additional 50,000 ponchos to the US market. Marc expects to visit these potential customers in the US in May and start deliveries in July. The marketing team have already put down a deposit of $15,000 to start a strong advertising campaign in the US; the $50,000 balance is expected to be paid when all details are confirmed. The campaign will require another 5,000 free samples of ponchos to be sent to key distributors and stores. Marc wants to know how many ponchos need to be sold in order to break-even with all these extra costs necessary to launch the ponchos in the US. Should the company abandon the US market, the sales team thinks they can focus their work to build stronger demand in Canada. Demand in Canada has the potential to increase to 275,000 ponchos after July when the lockdowns in Quebec and Ontario are expected to be lifted. Special order from Wobblyball (WB) 1KIT Wobblyball (WB) is a large pet toy and clothing distributor in the US. WB asked PR to produce by July a special stab-resistant vest (SRV) for small dogs to protect them from coyotes and birds of prey that can injure or kill them. These vests differ from the current camouflage ponchos PR makes: they have several sharp metal spikes all over the vests. WB will pay $25 for each vest. The cost to manufacture the SRV will be $18 each. If this order is accepted, PR will have to buy a new machine at a cost of $120,000 to inplant the metal spikes. The new machine will be able to produce 20 SRVs per hour. WB offers to buy 70,000 SRVs in one year. WB has made it clear that the SRV order has to be produced in total or not at all. PR currently produces 250,000 poncho, has a capacity of 10,000 machine hours available for both the SRV and existing camouflage poncho production and fixed costs of $400,000 for its regular production activity. PR produces 40 ponchos per hour. The firm estimates that the variable cost of producing camouflage poncho is $3.5 and each poncho sells for $6. Marc asks you to recommend if PR should accept the special order. He wonders if US expansion or more demand from the rest of Canada would affect your recommendations. In the meeting, Marc showed hesitancy to expand sales of ponchos to the US market. He referred to the US market as a risky proposition. He preferred PR increase demand for existing ponchos in Canada. Marc believes demand in Canada can increase up to 275,000 and staff may be able to negotiate harder to get WB to decide to accept any quantity of the SRV order. Marc wants you to determine the mix of SRV vests and ponchos that PR should produce should this scenario work.A B C D E F G H K Exhibit II Pickleroach Inc. (PR) Special Order Analysis Formula Purpose: To determine if PR should accept the special order from WB Business Breakeven=Fixed Costs/ Gross Profit Margin Status Quo Special Order Revenue Gross Profit Margin= (net income- the cost of goods)/ Revenue Selling price/unit $25.00 Volume 70,000.00 opportunity cost Machine Hours Variable cost $18.00 20 hours 40 hours Chapter 7 Fixed cost $400,000.00