I have my potential answers on excel, and I want to make sure Im doing it right with what answers you guys give me. it'd be much appreciated!

LongLife, LLC manufactures rechargeable batteries for the personal and recreational drone industry. The company signed a contract with Best Buy electronics to produce three different lithium-ion battery packs for a new line of retail drones. The contract calls for producing three types of battery packs. LongLife agreed to supply 200,000 battery packs of their LL-mod-A; 100,000 batteries of their LL-mod-B and 150,000 batteries of LL-mod-C.

LongLife manufactures the battery packs at plants located in China and South Korea. Each plant can manufacture up to 230,000 battery packs next year. The unit cost of the battery packs differs at the two plants because of differences in production equipment and wage rates. The unit costs for each battery pack at each manufacturing plant are as follows:

Product	China	South Korea
LL-mod-A	5.95	5.98
LL-mod-B	5.98	6.08
LL-mod-C	6.34	6.15

The LL-mod-A and LL-mod-B battery packs are produced using similar production equipment available at both plants. However, each plant has a limited capacity for the total number of LL-mod-A and LL-mod-B battery packs produced. The combined LL-mod-A and LL-mod-B production capacities are 175,000 units at the China plant and 160,000 units at the South Korea plant. The LL-mod-C production capacities are 75,000 units at the China plant and 100,000 units at the South Korea plant. The cost of shipping from the China plant is $0.18 per unit, and the cost of shipping from the South Korea plant is $0.10 per unit.

Questions

• Develop production and shipping plan that shows how many units of each battery pack should be produced at each plant in order to minimize the total production and shipping cost associated with the new contract. What is the total cost to manufacture and ship battery packs next year? How much can LongLife expect to incur for manufacturing costs at each plant? For shipping costs from each plant? How much excess production capacity does LongLife have? How much would it cost LongLife to produce and ship 5000 more LL-mod-A battery packs? Five thousand more LL-mod-B battery packs Five thousand more LL-mod-C battery packs? If LongLife decides to increase their production capacity of LL-mod-C battery packs, which plant would you recommend they consider? Why?
• If LongLife required each plant to produce at least 1000 battery packs of each model, how much would this requirement cost the company?