For the LP problem presented in the 'Problem Formulation' worksheet, set up and solve the LP using Solver in the 'Solver Solution' worksheet to find the optimal solution and generate the Answer and Sensitivity Reports.

Once complete, answer the questions below and upload the complete spreadsheet with the Solver set-up and solution/sensitivity analysis intact to D2L.
What is the minimum net profit required for crude type C1 before we would use any in the refining process? Exlpain/justify your response.
How low could the net profit on crude type 'A' be and still have our current optimal solution remain optimal

Oceanside marine company manufactures special metallic materials and decorative fittings for luxury yachts that require highly skilled labor. oceanside uses standard costs to prepare its flexible budget. for the first quarter of the year, direct materials and direct labor standards for one of their popular products were as follows: direct materials: 2 pound per unit; $ 11 per pound direct labor: 2 hours per unit; $ 19 per hour oceanside produced 2 comma 000 units during the quarter. at the end of the quarter, an examination of the direct materials records showed that the company used 7 comma 500 pounds of direct materials and actual total materials costs were $ 98 comma 100. what is the direct materials cost variance? (round any intermediate calculations to the nearest cent, and your final answer to the nearest dollar.)

Jordan, inc. sells fireworks. the company’s marketing director developed the following cost of goods sold budget for april, may, june, and july. april may june july budgeted cost of goods sold $62,000 $72,000 $82,000 $88,000 jordan had a beginning inventory balance of $3,000 on april 1 and a beginning balance in accounts payable of $14,600. the company desires to maintain an ending inventory balance equal to 15 percent of the next period’s cost of goods sold. jordan makes all purchases on account. the company pays 65 percent of accounts payable in the month of purchase and the remaining 35 percent in the month following purchase. required prepare an inventory purchases budget for april, may, and june. determine the amount of ending inventory jordan will report on the end-of-quarter pro forma balance sheet. prepare a schedule of cash payments for inventory for april, may, and june. determine the balance in accounts payable jordan will report on the end-of-quarter pro forma balance sheet.

The following transactions occurred during july: received $1,000 cash for services provided to a customer during july. received $4,000 cash investment from bob johnson, the owner of the business received $850 from a customer in partial payment of his account receivable which arose from sales in june. provided services to a customer on credit, $475. borrowed $7,000 from the bank by signing a promissory note. received $1,350 cash from a customer for services to be rendered next year. what was the amount of revenue for july?