Assignment Prompt & Instructions
[>Accounting homework help](https://www.sweetstudy.com/fields/business-finance-accounting)
1. You are thinking of opening a small copy shop. Renting a copier for a year costs $5000, and operating the copier costs $0.03 per copy. Other fixed costs of running the store will amount to $400 per month. You plan to charge an average of $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year. Find the annual profit for one to five copiers rented and the daily demands of 500, 1000, 1500, and 2000 copies daily. That is, find the yearly profit of each of these combinations of copiers rented and daily demand. If you rent three copiers, what daily demand for copies will allow you to break even? Graph profit as a function of the number of copiers for a daily demand of 500 copies and a daily demand of 2000 copies. Interpret your graphs.
1. A company manufactures and sells a product in the United States in England. The unit cost of manufacturing is $50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent −2.4 Develop a model for the company’s profit (in dollars) as a function of the price it charges (in pounds). Then, a data table will be used to find the profit-maximizing price for the nearest pound. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?
2.In PC Tech’s product mix problem, assume there is another PC model, the VXP, that the company can produce in addition to the Basics and XPs. Each VXP requires eight hours for assembling, three hours for testing, $275 for component parts, and sells for $560. At most 50 VXPs can be sold. Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix. You should find that the optimal solution is not integer-valued. If you round the values in the decision variable cells to the nearest integers, is the resulting solution still feasible? If not, how might you obtain a feasible solution that is at least close to optimal? Continuing the previous problem, perform a sensitivity analysis on the selling price of VXPs. Let this price vary from $500 to $650 in increments of $10, and keep track of the values in the decision variable cells and the objective cell. Discuss your findings. Again, continuing Problem 2, suppose that you want to force the optimal solution to be integers. Do this in Solver by adding a new constraint. Select the decision variable cells for the left side of the constraint, and in the middle dropdown list, select the “int” option. How does the optimal integer solution compare to the optimal noninteger solution in Problem 2? Are the decision variable cell values rounded versions of those in Problem 2? Is the objective value more or less than in Problem 2?If all of the inputs in PC Tech’s product mix problem are nonnegative (as they should be for any realistic version of the problem), are there any input values such that the resulting model has no feasible solutions? (Refer to the graphical solution.)There are five corner points in the feasible region for the product mix problem. We identified the coordinates of one of them: (560, 1200). Identify the coordinates of the others. Only one of these other corner points has positive values for both decision variable cells. Discuss the changes in the selling prices of either or both models that would be necessary to make this corner point optimal. Two of the other corner points have one decision variable cell value positive and the other zero. Discuss the changes in the selling prices of either or both models that would be necessary to make either of these corner points optimal.Using the graphical solution of the product mix model as a guide, suppose there are only 2800 testing hours available. How do the answers to the previous problem change? (Is the previous solution still optimal? Is it still feasible?)8.Again continuing Problem 2, perform a sensitivity analysis where the selling prices of Basics and XPs simultaneously change by the same percentage, but the selling price of VXPs remains at its original value. Let the percentage change vary from −25% to 50% in increments of 5%, and keep track of the values in the decision variable cells and the total profit. Discuss your findings.9.Consider the graphical solution to the product mix problem. Now imagine that another constraint—any constraint—is added. Which of the following three things are possible: (1) the feasible region shrinks; (2) the feasible region stays the same; (3) the feasible region expands? Which of the following three things are possible: (1) the optimal value in objective cell decreases; (2) the optimal value in objective cell stays the same; (3) the optimal value in objective cell increases? Explain your answers. Do they hold just for this particular model, or do they hold in general?
2. Suppose, as a matter of corporate policy, that General Flakes decides not to advertise on the “Rachael Ray” show. Modify the original advertising model appropriately and find the new optimal solution. How much has it cost the company to make this policy decision?
3. Five employees are available to perform four jobs. The time it takes each person to perform each job is given in the file P05_50.xlsx. Determine the assignment of employees to jobs that minimizes the total time required to perform the four jobs. (A blank indicates that a person cannot do that particular job. Also, assume that no person can do more than one job.)
3.NASA must determine how many of three types of objects to bring on board the space shuttle. The weight and benefit of each of the items are given in the file P06_42.xlsx. If the space shuttle can carry up to 2000 pounds of items 1 through 3, how many of each item should be taken on the space shuttle, assuming that at least one of each is necessary?
4.n the electricity pricing model in Example 7.4, the demand functions have positive and negative coefficients of prices. The negative coefficients indicate that as the price of a product increases, demand for that product decreases. The positive coefficients indicate that as the price of a product increases, demand for the other product increases.
Increase the magnitudes of the negative coefficients from −0.013 and −0.015 to −0.017 and −0.020, and then rerun Solver. Do the changes in the optimal solution go in the direction you would expect? Explain.Increase the magnitudes of the positive coefficients from 0.005 and 0.003 to 0.007 and 0.005, and then rerun Solver. Do the changes in the optimal solution go in the direction you would expect? Explain. Make the changes in parts a and b simultaneously, and then rerun Solver. What happens now?
4..In the truck-loading problem in Example 8.3, we assumed that any product could be loaded into any compartment. Suppose the following are not allowed: product 1 in compartment 2, product 2 in compartment 1, and product 3 in compartment 4. Modify the model appropriately, and then use Evolutionary Solver to find the new optimal solution. (Hint: Add a penalty to the objective for violating these new constraints.)
– [\
\
Unit1-HWAssignmentP02_22.xlsx](https://www.sweetstudy.com/files/unit1-hwassignmentp02-22-xlsx-10284763 "Unit1-HWAssignmentP02_22.xlsx")
– [\
\
Unit1HWAssignmentP02_30.xlsx](https://www.sweetstudy.com/files/unit1hwassignmentp02-30-xlsx-10284765 "Unit1HWAssignmentP02_30.xlsx")
– [\
\
Unit2-HWAssignment1-P03_02-updated-1.xlsx](https://www.sweetstudy.com/files/unit2-hwassignment1-p03-02-updated-1-xlsx-10284767 "Unit2-HWAssignment1-P03_02-updated-1.xlsx")
– [\
\
Unit2-HWAssignment2-Advertising1Finished-updated.xlsx](https://www.sweetstudy.com/files/unit2-hwassignment2-advertising1finished-updated-xlsx-10284769 "Unit2-HWAssignment2-Advertising1Finished-updated.xlsx")
– [\
\
Unit3-HWAssignment2-P06_42-updated-1.xlsx](https://www.sweetstudy.com/files/unit3-hwassignment2-p06-42-updated-1-xlsx-10284771 "Unit3-HWAssignment2-P06_42-updated-1.xlsx")
– [\
\
Unit3-HWAssignment1-P05_50-updated.xlsx](https://www.sweetstudy.com/files/unit3-hwassignment1-p05-50-updated-xlsx-10284773 "Unit3-HWAssignment1-P05_50-updated.xlsx")
– [\
\
Unit4-HWAssignment2-LoadingTruckFinished-updated.xlsx](https://www.sweetstudy.com/files/unit4-hwassignment2-loadingtruckfinished-updated-xlsx-10284777 "Unit4-HWAssignment2-LoadingTruckFinished-updated.xlsx")
– [\
\
Unit4-HWAssignment1-ElectricityPricingFinished-updated.xlsx](https://www.sweetstudy.com/files/unit4-hwassignment1-electricitypricingfinished-updated-xlsx-10284779 "Unit4-HWAssignment1-ElectricityPricingFinished-updated.xlsx")
– a year ago