A bike company receives bike orders every week and fulfills them according to order’s type. The following table shows frequency and price of the company's products. a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table. b) Calculate average and total price.
Q: Question 4. • Formulate this problem as a LP in which the objective is to minimize the total cost? •…
A: Find the given details below:
Q: Don't use Ai and any gpt tool Answer as soon as possible Explain the concept of Total Quality…
A: The termTotal Quality management (TQM) is a way of thinking and system that can be applied to…
Q: Hau Lee Furniture, Inc., spends 45% of its sales dollars in the supply chain and finds its current…
A: a) What percentage improvement is needed in the supply chain strategy for profit to improve to…
Q: The state and local police departments are trying to analyze crime rates so they can shift their…
A: For the p-chart with a 95% confidence level (Z = 1.96), the parameters are:P≈0.00708Sp≈0.0242UCL ≈…
Q: How would you identify skills gaps in the workforce? What skills will berequired in the future that…
A: Identifying skills gaps in the workforce and anticipating future skills requirements are crucial…
Q: d iscuss the role of supervisors or managers in conducting traditional performance reviews.
A: Performance evaluations are essential to an employee's professional development in an organisation…
Q: A seafood distribution company specializes in delivering fresh lobsters from their harvesting sites…
A: Find the given details below:
Q: (a) Draw the network representation for this problem. (b) Build a model to minimize the…
A: The network diagram of the transshipment problem is shown below.The network diagram represents the…
Q: How can companies use market research to validate and refine their value propositions?
A: Market research serves as a vital tool for companies seeking to validate and refine their value…
Q: 30. Market strategies are SELECTED based on which of the following Group of answer choices Costs and…
A: A marketing strategy is a comprehensive plan to accomplish the desired targets through connecting…
Q: As extracted from the case study, “the pandemic resulted in disrupted deliveries and many other…
A: The objective of the question is to identify and evaluate the measures and strategies that the…
Q: From the Research Topic below, kindly prepare an Introduction for a Journal entry sharing your…
A: Recruitment, selection, and retention are non-negotiable pillars of human resource management for…
Q: Michigan State Figurine Incorporated (MSF) sells crystal figurines to Spartan fans. MSF buys the…
A: a. MSF should order 100 units each time.b. MSF will place 5 orders in a year.c. The average…
Q: can you please answers all the blank and please provide me excel formular.
A: To roll up the individual product forecasts and compare them with the family data, we will first…
Q: 14. Describe how strategic planning is different from long- range planning.
A: Planning is the aspect of management that assists an individual in forecasting the future and making…
Q: In the following table the activities with their precedence sequence and expected time (days) are…
A: To create an Activity on Node (AON) diagram for the given project, we need to arrange the activities…
Q: Summarize and explain the ethical considerations in busing immigrants to sanctuary cities. Describe…
A: Busing immigrants to sanctuary cities involves various ethical considerations, environmental…
Q: Please help with question #2. The based country is Trinidad and the countries trading to is…
A: Let's take a look at a multinational company (MNC) that trades with Australia, Colombia, and…
Q: Question For this assignment, students are asked to simulate their own multinational corporation…
A: Multinational businesses (MNCs) are essential to international commerce and economic progress in an…
Q: The table below comprises of demand from the last 10 months: Month Demand 1 31 2 34 3 33…
A: The answers is provide in given below. If it is useful to you, Please like it.Explanation:Step…
Q: Problem 16A: ROLLED DOWN unit forecast for part C is 22, F is 2, I is 254, and L is 3. Can you…
A: To solve Problem 16A and compare the individual product forecasts with the family data and revise…
Q: (Revenue Mgmt) Donut Shop Donna's Delicious Donuts (DDD) produces 380 donuts each morning. There are…
A: Number of donuts produced = 380 per dayMinimum 30% donuts made will be held back for tour demand20%…
Q: Are Key Suppliers Part of the Sourcing Team Process?
A: Operation management is an aspect of management that deals with the management of the production,…
Q: University Ceramics manufactures plates, mugs, and steins that include the campus name and logo for…
A: Find the given details below:Since you have submitted multiple questions with multiple subparts, as…
Q: Project Management Homework-Project Crashing Use the following scenario and data to answer all…
A: Question 3: Cost of Crashing Activity D by One WeekAnswer: 600Here's how we find the cost of…
Q: From the letters a, b, c, d, and e, how many four-letter groups can be formed if each letter can be…
A: The objective of the question is to find out the number of four-letter groups that can be formed…
Q: There are three major lessons we can learn from this course: (1) Be on the lookout for what is…
A: Because industries are dynamic, operations managers must adopt a forward-thinking strategy to remain…
Q: The frenzy of GameStop, AMC and Reddit has made news across the world. What do you think will be…
A: Financial management is the aspect of management that is concerned with or manages all the…
Q: Internal failure costs
A: The issue here is to identify which of the given choices addresses a kind of cost that is directly…
Q: You have the following time and cost information for use in a time-cost CPM scheduling model.…
A: Part 1: AnswerThe correct answer is: A = $200, B = $300, C = $400Explanation:Part 2: Approach to…
Q: Lance Armstrong’s Bike Shop is behind on a custom bike and needs to crash 8 hours of time from the…
A: In project management, a crashing schedule is based on the technique used to compress the project…
Q: Master production schedule Week Leather Fabric 1 17 67 2 22 62 3 20 65 4 24 62 5 Total labor hours…
A: Find the given details below:
Q: Problem 16A: ROLLED DOWN unit forecast for part C is 22, F is 2, I is 254, and L is 3.
A: To solve Problem 16A, we need to roll up the individual product forecasts into product families and…
Q: Suppose Charlene Brewster has times (in seconds) of 8.3, 8.6, 8.2, 8.4, 8.8, 8.6 and a performance…
A: Operation management is an aspect of management that deals with the management of the production,…
Q: 14 10 11 32 The postmaster of a small western town receives a certain number of complaints each day…
A: Sample No. of complaints (C)14210314485966758129131071161241321410
Q: Benny the Barber owns a one-chair shop. At barber college, they told Benny that his customers would…
A: Arrival rate = 4.0 customers per hourBenny's average service time = 8 minutes to give a haircut.In,…
Q: Below are 6 tasks in a system where the m stands for minutes it takes to complete each task.…
A: The following tasks are there in the system:Task C and Task D are performed simultaneously.
Q: What are the ethical considerations when entering into a no bid or non competitive contract?
A: A no-bid or non-competitive contract is an agreement for procurement of goods or services between…
Q: The optimal solution of this linear programming problem is at the intersection of constraints 1 and…
A: The coefficient of x1 can vary within the range where the objective function coefficient is between…
Q: Within an organization, democratic decision making tends to lead to Group of answer choices more…
A: The objective of the question is to understand the impact of democratic decision making within an…
Q: Don't give Al solution pls Supply Chain Management can be described as the synchronisation of a…
A: A supply chain refers to an arrangement of interdependent systems, resources, capacities, and…
Q: Project management is a disciplined approach to planning, organizing, executing, and controlling…
A: A technique for organising, planning, directing, and regulating resources to accomplish particular…
Q: Below is a table of data collected over a six-month period in a local grocery store. Construct a…
A: 38%Explanation:Pareto analysis is a decision-making technique used for business decision-making and…
Q: Don't use Ai and any gpt tool Answer as soon as possible Explain the concept of Total Quality…
A: The termTotal Quality management (TQM) is a way of thinking and system that can be applied to…
Q: Project Management Homework-Project Crashing Use the following scenario and data to answer all…
A: Crashing is a technique used to shorten the schedule duration for the least incremental cost by…
Q: You are to share with the audience examples of domestic and international movement of goods. Provide…
A: Example:Product: Temperature-controlled pharmaceutical product Quantity: 300 casesOuter Box…
Q: R7.3. A farm sells its own produce in its large retail and wholesale outlets. It can produce…
A: Linear programming is a mathematical method used to find the best possible outcome or solution from…
Q: Bobby, another enterprising barber, is thinking about advertising in the local newspaper since he is…
A: The number of units or clients that arrive within a specific time frame is known as the arrival…
Q: ased on the Mt. Kumar Road project in Grenada, critically assess in paragraph format whether or not…
A: Infrastructure projects are vital for economic development and public well-being. Grenada's Mt.…
Q: Draw the network diagram. Calculate the expected duration and variance of each activity. Calculate…
A: Project management is the branch of management that deals with organizing and overseeing the…
Please answer in excel format
A bike company receives bike orders every week and fulfills them according to order’s type. The following table shows frequency and price of the company's products.
- a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table.
- b) Calculate average and total price.
Step by step
Solved in 4 steps with 9 images
- Struggling with answering this question A manufacturer produces three types of humidifiers. The retail price of Humidifier Regular (HR) is $60 with variable costs of $20. Humidifier Advanced (HA) sells for $200 for its advanced features. This model’s variable costs are $80. Humidifier Simple (HS) is a simplified version and only sells for $25 with variable costs of $15. The manufacturer has machines and facilities worth $320,000 annually. The sales data show that 1000 units of HR, 2000 units of HA, and 10,000 units of HS was sold last year. Calculate the break-even point of the firm. The firm has some idle capacity at these volumes and chooses to cut the selling price of HR from $60 to $45, believing that its sales volume will rise from 1000 units to 2500 units. What is the revised break-even point?You work for a small retail store. You must decide how many cases of kombucha to order. Twenty cases fit on a pallet and because of shipping costs, orders must be placed in multiples of 20. You can either order 20, 40, 60, 80 or 100 cases. Each case costs $15. If you order more than 1 pallet, you receive a discount of 5% per additional pallet ordered (2 pallets would be 5%, 3 would be 10%, etc). The cases can be sold for $25 each. Any that are left unsold can be sold to a discount store for $10. Your records suggest that the probability that you will sell 25 cases is 20%, 45 cases is 45%, 65 cases is 20% and 85 cases is 15%. a) Construct a payoff table to provide reflect the decisions and outcomes What would be your decision based on each of the following? Maximin Maximax Minimax regret Expected value Overall - what would you do? Why?Product K was introduced to the market some time ago and is now about to enter the maturity stage of its life cycle. The maturity stage is expected to last for ten weeks. Each unit has a variable cost of $38 and takes one standard hour to produce.The Managing Director is unsure which of four possible prices the company should charge during the next ten weeks. The following table shows the results of some market research into the level of weekly demand at alternative prices:Selling price per unit ($) 100 85 80 75Weekly demand (units) 600 800 1,200 1,400REQUIREDWhich one of the four selling prices should be charged for Product K in order to maximize its contribution during its maturity stage?
- 4. A publisher prints copies of a popular weekly tabloid for distribution and sale. The fixed costs are $500 per print run, with each copy printed costing an additional $0.40. If C(q) is the cost function (in $) of the price of the print run as a function of copies printed, what is the formula for C(q)? Select one: a. C(q) = 500 + 0.4q b. C(q) = 500q + 0.4 c. C(q) = (500 + 0.4)q d. C(q) = 500 - 0.4q e. C(q) = 500q - 0.4 5. A hot dog vendor sells an average of 50 hot dogs during a Little League baseball game. If the sales are Normally distributed with a standard deviation of 7 hot dogs, what is the probability the vendor will sell between 45 and 65 hot dogs? Select one: a. 74.50% b. 92.36% c. 99.78% d. 174.50% e. 2.14 f. -0.71 g. 0.71Month Sales January 250 February 350 March 240 April 260 May 280 June 330 July 220 August 310 September 235 October 300 November 240 December 230 A.What is the value of MSE (mean squared error)? The answer is . (Make sure no decimal place and no comma. EX: 1234) B.What is the optimal alpha value to minimize inaccuracy? The answer is . (Make sure two decimal places.)Explain the 4V-model and some examples of the implications they have for each V. What can the model be used for?
- Zara stores in the United States stocks a particular type of designer denim jeans in the United States. It stores 500 pairs of jeans each month from its two suppliers. The Hong Kong supplier charges Zara $11 per pair of jeans, and the Colombian supplier charges $16 per pair (and then Zara marks them up almost 1,000%). Although the jeans from Hong Kong are less expensive, they also have more defects than those from Colombia. Based on past data, Zara estimates that 7% of the Hong Kong jeans will be defective compared to only 2% from Colombia and Zara does not want to import any more than 5% defective items. However, Zara does not want to rely on a single supplier, so it wants to order at least 20% from each supplier every month. A. Formulate a linear programming model for this problem. B.Solve the linear programming model graphically. Use either iso-line or corner point method. How many of each should Zara buy? C. How much will Zara pay for them? D. If the Hong Kong supplier were able to…Zara stores in the United States stocks a particular type of designer denim jeans in the United States. It stores 500 pairs of jeans each month from its two suppliers. The Hong Kong supplier charges Zara $11 per pair of jeans, and the Colombian supplier charges $16 per pair (and then Zara marks them up almost 1,000%). Although the jeans from Hong Kong are less expensive, they also have more defects than those from Colombia. Based on past data, Zara estimates that 7% of the Hong Kong jeans will be defective compared to only 2% from Colombia and Zara does not want to import any more than 5% defective items. However, Zara does not want to rely on a single supplier, so it wants to order at least 20% from each supplier every month.a. Formulate a linear programming model for this problem. b. Solve the linear programming model graphically. Use either iso-line or corner point method. How many of each should Zara buy? c. How much will Zara pay for them? solve in excel Speak SpeakJulie James is opening a lemonade stand. She believes the fixed cost per week of running the stand is $50.00. Her best guess is that she can sell 300 cups per week at $0.50 per cup. The variable cost of producing a cup oflemonade is $0.20.a. Given her other assumptions, what level of sales volume will enable Julie to break even?b. Given her other assumptions, discuss how a change in sales volume affects profit.c. Given her other assumptions, discuss how a change in sales volume and variable cost jointly affect profit.d. Use Excel’s Formula Auditing tools to show which cells in your spreadsheet affect profit directly.
- Irwin’s sells a particular model of fan, with most of the sales being made in thesummer months. Irwin’s makes a one-time purchase of the fans prior to eachsummer season at a cost of $40 each and sells each fan for $60. Any fans unsoldat the end of the summer season are marked down to $29 and sold in a special fallsale. Virtually all marked-down fans are sold. The following is the number of salesof fans during the past 10 summers: 30, 50, 30, 60, 10, 40, 30, 30, 20, 40.a. Estimate the mean and the variance of the demand for fans each summer.b. Assume that the demand for fans each summer follows a normal distribution,with mean and variance given by what you obtained in part (a). Determine theoptimal number of fans for Irwin’s to buy prior to each summer season.c. Based on the observed 10 values of the prior demand, construct an empiricalprobability distribution of summer demand and determine the optimal numberof fans for Irwin’s to buy based on the empirical distribution.d. Based on your…Which of the following is NOT a determinant of the demand for good X?Clippers Inc. (CI) manufactures two types of garden clippers. A light-duty model, called the “half-inch,”is intended for clipping branches and stems up to one-half inch thick. The “one-inch” model is designedfor heavier stems and branches. To boost sales, CI decided at the beginning of the current year to reducethe price of the half-inch model to better position its price relative to some key competitors. On the otherhand, CI felt that the one-inch model was technically superior to competitors’ models and decided that asmall price increase was appropriate. The data for the current and prior year are as follows:Current Year Prior YearSales units 7,200 6,500Sales mix for each productHalf-inch model 50% 30%One-inch model 50% 70%PriceHalf-inch model $12.00 $14.00One-inch model $36.00 $32.00Variable cost per unitHalf-inch model $6.00 $6.00One-inch model $8.00 $8.00Fixed cost $35,000 $35,000Required1. Prepare a comparative contribution income statement for CI for the current year that shows…