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