write my assignment 15985

For this problem, please include explanations of variables, objective function and constraints for the solution. A screenshot of how to solve it in excel would also be appreciatedAttachment 1Attachment 2Case : Delhi FoodsManisha Patel recently completed her first week of work as a summer intern at Delhi Foods .Earlier this morning . Manisha's boss , the director of marketing , asked her to come up with arecommendation on the level of marketing expenses ( advertising and promotion expenditures )for a line of frozen Indian dinners as it enters its seventh year in the marketplace . Exhibit 8 . 1 .which Manisha received from her boss , contains an accounting summary of essential productcosts and revenues in the first 6 years . during which there has been some trial - and - error exper -Imentation with marketing policies . For year ] . the table shows projections for the coming yearEXHIBIT 8.1Summary of Product Costs and RevenuesYear267Demand ( cartons )3. 2003. 4003.50.03. 60.03. 8004. 4004. 700Revenue $ ( 090 )62. 00063. 0.0066. 00 075. 0.0086. 00098.000105, 000ProductionMaterials27. 00029. 00030. 00 035. 00039. 00033. 00035, 000Other variables1 . 7002.2002.80 03.50.02, 40010. 8001 1 , 60.0Fixed4. 5004. 7004. 90.05. 0.005. 30.05. 6005. 90.0MarketingAdvertising*10. 30011 . 70015. 0.0 016. 20.017. 80022. 00024, 0.00Promotion9.0006.0.004. 0.0 01 1. 00012,00013.00014, 0:00Overhead6. 0.006. 0.005. 0.0 05. 0.005. 0.005.0.006.000Operating margin3.5003. 40.04. 30.0( 70 0 )4. 5008. 6008.50.0

For this problem, please include explanations of variables, objective function and constraints for the solution. A screenshot of how to solve it in excel would also be appreciated

  • Attachment 1
  • Attachment 2

Case : Delhi FoodsManisha Patel recently completed her first week of work as a summer intern at Delhi Foods .Earlier this morning . Manisha’s boss , the director of marketing , asked her to come up with arecommendation on the level of marketing expenses ( advertising and promotion expenditures )for a line of frozen Indian dinners as it enters its seventh year in the marketplace . Exhibit 8 . 1 .which Manisha received from her boss , contains an accounting summary of essential productcosts and revenues in the first 6 years . during which there has been some trial – and – error exper -Imentation with marketing policies . For year ] . the table shows projections for the coming yearEXHIBIT 8.1Summary of Product Costs and RevenuesYear267Demand ( cartons )3. 2003. 4003.50.03. 60.03. 8004. 4004. 700Revenue $ ( 090 )62. 00063. 0.0066. 00 075. 0.0086. 00098.000105, 000ProductionMaterials27. 00029. 00030. 00 035. 00039. 00033. 00035, 000Other variables1 . 7002.2002.80 03.50.02, 40010. 8001 1 , 60.0Fixed4. 5004. 7004. 90.05. 0.005. 30.05. 6005. 90.0MarketingAdvertising*10. 30011 . 70015. 0.0 016. 20.017. 80022. 00024, 0.00Promotion9.0006.0.004. 0.0 01 1. 00012,00013.00014, 0:00Overhead6. 0.006. 0.005. 0.0 05. 0.005. 0.005.0.006.000Operating margin3.5003. 40.04. 30.0( 70 0 )4. 5008. 6008.50.0

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Comments are closed.

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp