High School

Kite 'N String manufactures old-fashioned diagonal and box kites from high-strength paper and wood.

- Each diagonal kite nets the company a $3 profit and requires 6 square feet of paper and 5 linear feet of wood.
- Each box kite nets a $5 profit and requires 6 square feet of paper and 10 linear feet of wood.
- Each kite needs to be packaged in a single box before it is sold to customers.

This week, Kite 'N String has:
- 1500 boxes for packaging (one for each kite)
- The capacity to use 10,000 square feet of paper and 12,000 linear feet of wood for kite production

Kite 'N String needs to make production decisions in order to maximize the company's total profit for this week. Implement this problem into Excel and solve for the optimal solutions. What is the optimal total profit?

Answer :

The optimal total profit for Kite 'N String is $14,800.

To maximize the company's total profit for the week, Kite 'N String needs to manufacture 200 diagonal kites and 1000 box kites. This production plan will require 2000 square feet of paper and 12,000 linear feet of wood, which are within the production capacity of Kite 'N String. The production plan will also require 1200 boxes for packaging the kites, which is within the available packaging capacity of the company.

The first step in solving this problem is to set up the objective function and constraints in Excel. The objective function is the total profit, which is given by:

Profit = 3D + 5BWhere D is the number of diagonal kites and B is the number of box kites. The constraints are given by:

Paper: 2D + 6B ≤ 10,000

Wood: 5D + 10B ≤ 12,000

Boxes: D + B ≤ 1500

Non-negativity: D ≥ 0, B ≥ 0

These constraints represent the paper, wood, and box packaging capacity of the company, as well as the non-negativity constraint on the number of kites produced.

Once the constraints and objective function are set up, the Solver add-in in Excel can be used to find the optimal solution. The optimal production plan is to manufacture 200 diagonal kites and 1000 box kites, which results in a total profit of $14,800.

This production plan satisfies all the constraints and maximizes the company's total profit.

To know more about the optimal production plan, click here;

https://brainly.com/question/6348653

#SPJ11