Develop a simple spreadsheet dss program

Assignment Help Business Management

Reference no: EM131253657

As the head buyer for a major supermarket chain, you are constantly being asked by manufacturers and distributors to stock their new products. Over 50 new items are introduced each week. Many times, these products are launched with national advertising campaigns and special promotional allowances to retailers.

To add new products, the amount of linear shelf space allocated to existing products must be reduced or items must be eliminated altogether.

Develop a simple spreadsheet DSS program that you can use to estimate the change in profits from adding or deleting an item from inventory.

Your analysis should include input such as estimated weekly sales in units, the amount of linear shelf space allocated to stock an item (measured in inches), total cost per unit, and sales price per unit. Your analysis should calculate total annual profit by item and then sort the rows in descending order based on total annual profit.

Reference no: EM131253657

Questions Cloud

Determining the financial statement data : For the financial year 2013 the following financial statement data were available for Big Blue Pots Ltd and Small Red Pots Ltd. two competitor companies

Which of the three gambles given is best for this consumer : Which of the three gambles given is best for this consumer (granting the validity of all her judgments)?

Prepare the journal entries for the issuance of the bonds : On January 1, 2016, Gless Textiles issued $15 million of 8%, 10-year convertible bonds at 101. The bonds pay interest on June 30 and December 31. Each $1,000 bond is convertible into 40 shares of Gless’s no par common stock. Prepare the journal entri..

Calculate the return on the market value of equity : Calculate the return on the market value of equity for 2015. (Round your answer to 1 decimal place.) Calculate the price-earnings ratio for 2015. (Do not round your intermediate calculations. Round your answer to 1 decimal place.)

Develop a simple spreadsheet dss program : Develop a simple spreadsheet DSS program that you can use to estimate the change in profits from adding or deleting an item from inventory.

Write a brief summary of the median earnings : Based on your findings from the OOH, write a brief summary of the median earnings, number of current jobs, and projected job creation for the future for your selected occupations.

What is an accounts receivable aging report : The Howard Leasing Company is a privately held, medium-sized business that purchases school busses and leases them to school districts, churches, charitable organi- zations, and other businesses. What is an accounts receivable aging report? ? Why is..

Develop a simple spreadsheet dss program : Develop a simple spreadsheet DSS program that you can use to estimate the change in profits from adding or deleting an item from inventory.

Draw demand and supply graphs : Historical Immigration Patterns and Real Wages. Between 1870 and 1910, 60 million Europeans left Europe to go to the United States, Canada, Australia, and Argentina. This immigration sharply increased the labor force in these countries, but decrea..

User Account

All Pages