Hi can you help me with this assienment

Instructions

You are the operations manager of a fleet of commercial blue crab boats. Your crabs are essentially the same as other crabs. Your job is to maximize profits over the crabbing season by minimizing costs. In each month of the season, you must choose a level of output that minimizes costs.

Thecost simulation spreadsheet (Excel)contains market data, as well as a basic model for calculating costs for your fleet. Each month new data will come in, and you can use this spreadsheet to analyze your production decision.

Simulation

The simulation is comprised of six rounds. In each round, you have as much time as you like to choose a level of output. However, from the time you begin the simulation you have 48 hours to six rounds.

In each round, there is a single 'correct' profit-maximizing answer, and your grade on the simulation will be calculated as a percentage of the total possible profit in all rounds. After each round, you will receive a report from the Maryland Blue Crab Industry Advisory Committee consultant regarding your relative performance, and possibly some hints on best practices. You may step away from the simulation at any time to review material, provided you six rounds in the 48-hour window from the time you begin the simulation.

FC7500VC100Base5IncreasingQFCVCTCMC07,500.00-7,500.00-17,500.00105.007,605.00105.0027,500.00220.007,720.00115.0037,500.00345.007,845.00125.0047,500.00480.007,980.00135.0057,500.00625.008,125.00145.0067,500.00780.008,280.00155.0077,500.00945.008,445.00165.0087,500.001,120.008,620.00175.0097,500.001,305.008,805.00185.00107,500.001,500.009,000.00195.00117,500.001,705.009,205.00205.00127,500.001,920.009,420.00215.00137,500.002,145.009,645.00225.00147,500.002,380.009,880.00235.00157,500.002,625.0010,125.00245.00167,500.002,880.0010,380.00255.00177,500.003,145.0010,645.00265.00187,500.003,420.0010,920.00275.00197,500.003,705.0011,205.00285.00207,500.004,000.0011,500.00295.00217,500.004,305.0011,805.00305.00227,500.004,620.0012,120.00315.00237,500.004,945.0012,445.00325.00247,500.005,280.0012,780.00335.00257,500.005,625.0013,125.00345.00267,500.005,980.0013,480.00355.00277,500.006,345.0013,845.00365.00287,500.006,720.0014,220.00375.00297,500.007,105.0014,605.00385.00307,500.007,500.0015,000.00395.00317,500.007,905.0015,405.00405.00327,500.008,320.0015,820.00415.00337,500.008,745.0016,245.00425.00347,500.009,180.0016,680.00435.00357,500.009,625.0017,125.00445.00367,500.0010,080.0017,580.00455.00377,500.0010,545.0018,045.00465.00387,500.0011,020.0018,520.00475.00397,500.0011,505.0019,005.00485.00407,500.0012,000.0019,500.00495.00417,500.0012,505.0020,005.00505.00427,500.0013,020.0020,520.00515.00437,500.0013,545.0021,045.00525.00447,500.0014,080.0021,580.00535.00457,500.0014,625.0022,125.00545.00467,500.0015,180.0022,680.00555.00477,500.0015,745.0023,245.00565.00487,500.0016,320.0023,820.00575.00497,500.0016,905.0024,405.00585.00507,500.0017,500.0025,000.00595.00517,500.0018,105.0025,605.00605.00527,500.0018,720.0026,220.00615.00537,500.0019,345.0026,845.00625.00547,500.0019,980.0027,480.00635.00557,500.0020,625.0028,125.00645.00567,500.0021,280.0028,780.00655.00577,500.0021,945.0029,445.00665.00587,500.0022,620.0030,120.00675.00597,500.0023,305.0030,805.00685.00607,500.0024,000.0031,500.00695.00617,500.0024,705.0032,205.00705.00627,500.0025,420.0032,920.00715.00637,500.0026,145.0033,645.00725.00647,500.0026,880.0034,380.00735.00657,500.0027,625.0035,125.00745.00667,500.0028,380.0035,880.00755.00677,500.0029,145.0036,645.00765.00687,500.0029,920.0037,420.00775.00697,500.0030,705.0038,205.00785.00707,500.0031,500.0039,000.00795.00717,500.0032,305.0039,805.00805.00727,500.0033,120.0040,620.00815.00737,500.0033,945.0041,445.00825.00747,500.0034,780.0042,280.00835.00757,500.0035,625.0043,125.00845.00767,500.0036,480.0043,980.00855.00777,500.0037,345.0044,845.00865.00787,500.0038,220.0045,720.00875.00797,500.0039,105.0046,605.00885.00807,500.0040,000.0047,500.00895.00817,500.0040,905.0048,405.00905.00827,500.0041,820.0049,320.00915.00837,500.0042,745.0050,245.00925.00847,500.0043,680.0051,180.00935.00857,500.0044,625.0052,125.00945.00867,500.0045,580.0053,080.00955.00877,500.0046,545.0054,045.00965.00887,500.0047,520.0055,020.00975.00897,500.0048,505.0056,005.00985.00907,500.0049,500.0057,000.00995.00917,500.0050,505.0058,005.001,005.00927,500.0051,520.0059,020.001,015.00937,500.0052,545.0060,045.001,025.00947,500.0053,580.0061,080.001,035.00957,500.0054,625.0062,125.001,045.00967,500.0055,680.0063,180.001,055.00977,500.0056,745.0064,245.001,065.00987,500.0057,820.0065,320.001,075.00997,500.0058,905.0066,405.001,085.00