Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem Statement: Your small retail shop specializes in high-end mountain bikes. At this time, your store does not have any other products. You buy
Problem Statement: Your small retail shop specializes in high-end mountain bikes. At this time, your store does not have any other products. You buy them from the distributors and stock them in your shop. You have ONLY ONE employee besides yourself to help assemble and sell these bicycles. You need to develop a simple spreadsheet model to help you monitor this business's operations and help you track your projected profit (or loss) for the coming year. You would like to know which bikes are the most profitable, and you need to be able to see how other costs such as rent and utilities might affect your overall net profit or loss within that time frame. You have decided to develop a model using an MS Excel spreadsheet that will become a part of your Decision Support System (DSS). This model should provide an instant answer to the profitability of a given product at a given cost or selling price. It must also allow you to examine different scenarios when manipulating the product line offered and the set of critical variables such as markup, rent, and utilities. The model will help you decide the best course of action next year. Note: The selling price is based on a percentage markup over the cost and is derived by a formula. Your task is to put all of that information into a DSS model using MS Excel. Projected Data: Manufacturer Model Projected Sales GBI DXT 30 GBI PXT 59 Cannondale Six13 51 Giant Contend 32 Giant Defy 64 Trek CrossRip 19 Manufacturer Model Cost Each Total cost GBI DXT $ 1,202.68 $???? GBI PXT $1,161.32 $???? Cannondale Six13 $1,056.73 $???? Giant Contend $1,304.33 $???? Giant Defy $ 948.56 $???? Trek CrossRip $1,599.65 $???? Total Cost Of Projected Sales: $???? Markup: 27%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started