Develop a simple spreadsheet dss program

Assignment Help Business Management

Reference no: EM131253654

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: EM131253654

Questions Cloud

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..

What are their strategies for calling traditional divisions : In what way do contemporary artists consider issues of national and cultural identity? What are their strategies for calling traditional divisions into question through their art?

Prepare the necessary journal entries : At January 1, 2016, Brant Cargo acquired equipment by issuing a five-year, $125,000 (payable at maturity), 6% note. The market rate of interest for notes of similar risk is 10%. Prepare the necessary journal entries for Brant Cargo

Basis for developing future standards : In the U.S., the IASB and IFRS have been working together on existing frameworks to provide a basis for developing future standards. Describe the phases that they have been working on. Access the IFRS Website or some other authoritative source to get..

User Account

All Pages