1. mid-atlantic auto is evaluating their marketing plan for the sedans, suvs, and trucks they produce. a tv ad featuring this suv has been developed. the company estimates each showing of this commercial will cost $500,000 and increase sales of suvs by 3% but reduce sales of trucks by 1% and have no effect of the sales of sedans. the company also has a print ad campaign developed that it can run in various nationally distributed magazines at a cost of $750,000 per title. it is estimated that each magazine title the ad runs in will increase the sales of sedans, suvs, and trucks by 2%, 1%, and 4%, respectively. the company desires to increase sales of sedans, suvs, and trucks by at least 3%, 14%, and 4%, respectively, in the least costly manner. a. formulate an lp model for this problem. b. implement your model in a spreadsheet, and solve it. what it the optimal solution?

Georgia orchards produced a good crop of peaches this year. after preparing the following income statement, the company is concerned about the net loss on its no. 3 peaches. georgia orchards income statement for year ended december 31, 2017 no. 1 no. 2 no. 3 combined sales (by grade) no. 1: 300,000 ibs. @ $1.50/lb $ 450,000 no. 2: 300,000 ibs. @ $1.00/lb $ 300,000 no. 3: 750,000 ibs. @ $0.25/lb $ 187,500 total sales $ 937,500 costs tree pruning and care @ $0.30/ib 90,000 90,000 225,000 405,000 picking, sorting, and grading @ $0.15/ib 45,000 45,000 112,500 202,500 delivery costs 15,000 15,000 37,500 67,500 total costs 150,000 150,000 375,000 675,000 net income (loss) $ 300,000 $ 150,000 $ (187,500 ) $ 262,500 in preparing this statement, the company allocated joint costs among the grades on a physical basis as an equal amount per pound. the company’s delivery cost records show that $30,000 of the $67,500 relates to crating the no. 1 and no. 2 peaches and hauling them to the buyer. the remaining $37,500 of delivery costs is for crating the no. 3 peaches and hauling them to the cannery. required: 1. prepare reports showing cost allocations on a sales value basis to the three grades of peaches. separate the delivery costs into the amounts directly identifiable with each grade. then allocate any shared delivery costs on the basis of the relative sales value of each grade. (do not round intermediate calculations.)