Skip to main content

Business Management

MIS 2-2 Business Management

.Management Decision Problem 1,Section 2.5

 

Don’s Lumber Company on the Hudson River is one of the oldest retail lumberyards in New

York State. It features a large selection of materials for flooring, decks, moldings, windows,

siding, and roofing. The prices of lumber and other building materials are constantly changing. When a customer inquiries about the price on pre‐finished wood flooring, sales representatives consult a manual price sheet and then call the supplier for the most recent price. The supplier in turn uses a manual price sheet, which has been updated each day. Often the supplier must call back Don’s sales reps because the

company does not have the newest pricing information immediately on hand. Assess the business impact of this situation, describe how this process could be improved with information technology, and

identify the decisions that would have to be made to implement a solution. Who would make those decisions

 

Henry’s Hardware is a mom-and-pop business in Sacramento, California. Store space is limited and the rent has doubled over the past five years. The owners, Henry and Kathleen Nelson, are under pressure to use every square foot of space as profitably as possible. The Nelsons have never kept detailed records of stock in inventory or of their sales. As soon as a shipment of goods arrives, the items are immediately placed on store shelves to be sold. Invoices from suppliers are only kept for tax purposes. When an item is sold, the item number and price are rung up at the cash register. The Nelsons use their own judgment in identifying items that need to be reordered. Many times, however, they are caught short and lose a sale. What is the business impact of this situation? How could information systems help Henry and Kathleen run their business? What data should these systems capture? What reports should the systems produce? What decisions could the systems improve?

Improving Decision Making: Use a Spreadsheet to Select Suppliers

Software skills: Spreadsheet date functions, data filtering, DAVERAGE function

Business skills: Analyzing supplier performance and pricing

In this exercise, you will learn how to use spreadsheet software to improve management decisions about selecting suppliers. You will start with raw transactional data about suppliers organized as a large spreadsheet list. You will use the spreadsheet software to filter the data based on several different criteria to select the best supplies for your company.

spreadsheet attached



Comments

Post a Comment

Popular posts from this blog

Netanel (1996) talks about the NIEP theory approach to copyright and the democratic paradigm. Explain the difference between these in your own words. Lessig (2008) talks about read-only (RO) and read/write (RW) culture. How can copyright facilitate both of these?

chapter one Introduction A ‘‘Largely Ignored Paradox’’ The u.s. supreme court has famously labeled copyright ‘‘the engine of free expression.’’1 Copyright law, the Court tells us, provides a vital economic incentive for the creation and distribution of much of the literature, commentary, music, art, and film that makes up our public discourse. Yet copyright also burdens speech. We often copy or build upon another’s words, images, or music to convey our own ideas effectively. We cannot do that if a copyright holder withholds permission or insists upon a license fee that is beyond our means. And copyright does not extend merely to literal copying. It can also prevent parodying, remolding, critically dissecting, or incorporating portions of existing expression into a new, independently created work. Consider The Wind Done Gone, a recent, best-selling novel by African American writer Alice Randall. Randall’s novel revisits the setting and characters of Margaret Mitchell’s classic Civil War...
Post a Comment
Read more

1. Good time management for project managers includes initiating contact with key stakeholders only when there is a valid issue to deal with. -True -False

1. Good time management for project managers includes initiating contact with key stakeholders only when there is a valid issue to deal with. -True -False Click here for more on this paper ……. Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted 2. A project manager should identify a problem in terms of its alternate solutions so that team members can more easily reach a decision on how to solve the problem. -True -False 3. Networks are mutually beneficial alliances that are generally Click here for more on this paper ……. Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted governed by the law of: a Supply-demand b Brooks’s law c Reciprocity d A squeaky wheel e Risk-reward Click here for more on this paper ……. Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted 4...
Post a Comment
Read more

How did life in the British colonies contribute to creating a unique American identity?

How did life in the British colonies contribute to creating a unique American identity? How do you see that identity manifested in modern American society? 200 to 300 words Click here for more on this paper ……. Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted Assignment status :  Solved by our Writing Team at EssayCabinet.com. MAKE YOUR ORDER
Post a Comment
Read more