Use Excel to solve the linear programming problem.

For his classes, Professor Wright gives three types of quizzes, objective, recall, and recall-plus. To keep his students on their toes, he has decided to give at least 20 quizzes next quarter. The three types, objective, recall, and recall-plus quizzes, require the students to spend, respectively, 10 minutes, 30 minutes, and 60 minutes for preparation, and Professor Wright would like them to spend at least 12 hours(720 minutes) preparing for these quizzes above and beyond the normal study time. An average score on an objective quiz is 5, on a recall type 6, and on a recall-plus 7, and Dr. Wright would like the students to score at least 130 points on all quizzes. It takes the professor one minute to grade an objective quiz, 2 minutes to grade a recall type quiz, and 3 minutes to grade a recall-plus quiz. How many of each type should he give in order to minimize his grading time?

Terra Mesa Manufacturing uses a job order cost system to account for its production of specialty patio furniture. At the beginning of June, Terra Mesa had one job in Work in Process, job A75. Management has chosen direct labor cost as its activity base. The costs incurred to date on job A75 are as follows: Direct materials   $8260 Direct labor   10500 Overhead   13125 During June, Terra Mesa added the following costs for direct materials and direct labor to job A75: Direct materials   $2630 Direct labor   4620 Job A75 was competed on June 30. What is the cost of job A75? $26010 $39135 $44910 $42831

Anela is a computer scientist who is formulating a large and complicated program for a type of data processing. She has three ways of storing and retrieving data: cloud storage, disk, or hard drive. As an experiment, she sets up her program in three different ways: one using cloud storage, one using disks, and the other using a hard drive. Then she makes four test runs of this type of data processing on each program. The time required to execute each program is shown in the following table (in minutes). Use a 0.01 level of significance to test the hypothesis that the mean processing time is the same for each method. Hard Drive Cloud Disks 8.8 7.5 7.1 8.8 9.2 6.6 8.0 7.2 10.2 7.6 7.9 8.0   (i) Give the value of the level of significance. (ii) Find the sample test statistic. (Round your F Ratio to two decimal places. Round all other answers to four decimal places.) (vi) In the case of one-way ANOVA, make a summary table. (Round your answers to three decimal places.)…

TMA manufactures 37-in. high-definition LCD televisions in two separate locations: Location I and Location II. The output at Location I is at most 6500 televisions/month, whereas the output at Location II is at most 5000 televisions/month. TMA is the main supplier of televisions to Pulsar Corporation, its holding company, which has priority in having all its requirements met. In a certain month, Pulsar placed orders for 2600 and 4100 televisions to be shipped to two of its factories located in City A and City B, respectively. The shipping costs (in dollars) per television from the two TMA plants to the two Pulsar factories are as follows.   To Pulsar Factories From TMA     City A     City B Location I $7 $4    Location II $8 $8    TMA will ship x televisions from Location I to City A and y televisions from Location I to City B. Find a shipping schedule that meets the requirements of both companies while keeping costs, C (in dollars), to a minimum. Minimize      C =…

In her last semester at SPC, Polly Hedron needs to take Statistics, Composition 2, and Ethics. Because Polly is registering early, she has 14 choices for her section of Statistics, 14 choices for her section of Composition, and 13 choices for her section of Ethics. From how many possible schedules can Polly choose? (You may presume that none of these sections interfere with each other)

You are in charge of purchases at the student-run used-book supply program at your college, and you must decide how many introductory calculus, history, and marketing texts should be purchased from students for resale. Due to budget limitations, you cannot purchase more than 900 of these textbooks each semester. There are also shelf-space limitations: Calculus texts occupy 2 units of shelf space each, history books 1 unit each, and marketing texts 2 units each, and you can spare at most 1,400 units of shelf space for the texts. If the used book program makes a profit of $10 on each calculus text, $4 on each history text, and $8 on each marketing text, how many of each type of text should you purchase to maximize profit?