Use the table below to answer the following question(s). In the spreadsheet below, there is data on the price, cost, demand, and quantity produced for an item. There are also different "what if" values that can help a manager to calculate costs and revenue with variability in demand. JA Profit Model B 2 What-If Demand Values 3 Data |20,000 |40,000 |55,000 60,000 |65,000 4 |Unit Price ($) |Unit Cost ($) Fixed Cost ($) Demand Quantity Produced |50 |25 |550,000 |60,000 |55,000 15 17 19 10 Which of the following is the Excel formula to determine the number of units sold? =B8 =MIN(0,B8,B9) =MAX(0,B8,B9) =MIN(B8,B9)
Q: Market Company’s policy is to have 30% of the next month's sales on hand at the end of the current m...
A: Given- Month Projected Sales August 26,000 September 21,000 October 31,000
Q: The Wonderful Widget Company's earning have declined to the point where they need to reduce the numb...
A: When an employer eliminates a significant number of workers in order to cut company expenditures, th...
Q: Why is it important to avoid Type 1 Errors?
A: The null hypothesis can be stated as the typical statistical theory which recommends that no statist...
Q: The following network describes a transportation scenario in which there are four sources A, B, C, a...
A: Given data is
Q: Think of a specific mode of transportation in the Philippines. In no more than three (3) sentences f...
A: Due to increase industrialization and urbanization over time, the demand for transportation has als...
Q: What is Information Search Process (ISP)? Who initiated this method and how does the researchers ben...
A: Management information systems often called MIS systems can be stated as the division or department ...
Q: What are the essential parts of a successful HIPAA Security Compliance Program?
A: Assuring that all workers have access to the organization's formal HIPAA and confidentiality, polici...
Q: A systems specification document defines the project's scope and is sent to all key stakeholders for...
A: A systems specification document defines the system level functional and performance requirements, s...
Q: Calculate the Economic Order Quantities (EOQs) for the A items.
A: A item = Sample number 6 Annual usage (D) = 6500Ordering cost (O) = 50Holding cost (H) = 15 % of 97....
Q: Analyse the advantages and disadvantages of using process layout in a manufacturing plant. Provide r...
A: Process layout is the layout of the plant that helps the business to increase efficiency by arrangin...
Q: ABC Ltd. Wants to choose the best location for its new aluminum plant. The manager of productions an...
A: Breakeven analysis for facility location is a method to determine the optimal location which has the...
Q: Cans are made in a process with two resources. The first resource has a capacity of 11 cans per seco...
A: Given: 1st resource capacity =11 cans/sec2nd resource capacity =10 cans/sec 1st resource has workers...
Q: Bakery A uses the newsvendor model to manage its inventory of bread loat Bakery A sels bread for $46...
A:
Q: Solve for the predicted values of y and the residuals for the following data. Advertising 12.5 3.7 2...
A: Given-
Q: Suppose that the crash cost is $10 million, normal cost is $8 million, normal project time is 10 yea...
A: Project crashing is a method used in project management to increase the project time by decreasing t...
Q: in determining which process technology to be used to improve operational efficiency. Provide with r...
A: In its broadest sense, operational efficiency refers to a company's capacity to provide high-quality...
Q: A manufacturing company needs a Pareto diagram for the analysis of the following design department c...
A: Given, Element Dollars(in thousands) Progress Review 10 Support Activities 13 Qualification...
Q: Prepare an arrow diagram and a list of earliest and latest starts and finishes , the tota float and ...
A: D(duration)=given in the question as normal time ES (Early start)= The first activity from where the...
Q: Which one of the following perils would be covered under the commercial property policy broad form b...
A: Commercial property insurance covers the repair or replacement of building and building property dam...
Q: A circus is scheduled to appear in a city on a given date. The profits obtained are heavily dependen...
A: Find the Given details below:
Q: In quality assurance, to monitor characteristics that have discrete values and can be counted, we ca...
A: Quality assurance is the process of preventing and controlling defects in the products and services ...
Q: What is the best way to create a generic diagram of a business process of your choosing AFTER ERP Sy...
A: Enterprise resource planning is described as the sort of software application that can be used by or...
Q: In what circumstances is it required to raise a process exception?
A: Process exception is a condition or a situation in the process strategy where the whole process or a...
Q: Is globalization a cure for poverty?
A: At the start of the 21st century, the world economy was estimated to be worth $60 trillion. Over 77,...
Q: Budget Surplus Case Study A small midwestern city has a $1 million budget surplus. Two groups imme-...
A: given, A small midwestern city has a $1 million budget surplus. Two groups imme- diately begin vying...
Q: a. Construct a time series plot. What type of pattern exists in the data? ( b. Develop the three-wee...
A: Here, we have the table data that represent time-series data, we have data values over some periods,...
Q: What is the minimum number of weeks required for completing the project? What is the latest possible...
A: D(duration)=given in the question as normal time ES (Early start)= The first activity from where the...
Q: Multiple choice need help in completing question 8 and 14. 8. The just-in-time inventory system i...
A: Cost of quality - is described as a process that permits an organization to specify the scope to whi...
Q: A company makes two products (1 and 2). Each product requires time on two machines A and B. The spec...
A: Given data is Product 1 processing time on machine A = 2 hrs/unit Product 1 processing time on machi...
Q: Mention the trade off involved in deciding to have a one large centrally located facility instead of...
A: To be determined: The trade-off involves in deciding to have one large centrally located facility in...
Q: Kathy was a member of a selection panel for an editorial position. Jean was one of the unsuccessful ...
A: Personal issues can negatively impact the environment at the workplace and can also impact the perfo...
Q: Week Demand of beef 1 500 2 550 3 600 4 720 5 780 6 800 Corresponding weights are W1...
A: An accuracy of the forecasting method can decide by identifying the MAD value of the each method. Hi...
Q: a) Draw network diagram representing the project b) Find total float & free float for each activity ...
A: D(duration)=given in the question as normal time ES (Early start)= The first activity from where the...
Q: Respond to the following - the importance of the location decision is sometimes massively overrated ...
A: To be determined: the importance of the location decision is sometimes massively overrated and the f...
Q: What are the different types of costs which you may have to bear on operating a warehouse?
A: Warehouse management is described as the processes that include the operations carried out in a ware...
Q: Explain 1-2 sentences Operating Risk Process Stoppage Health and Safety After Sales Service Failu...
A: Operational risk is related to the failure of any process, policies, systems or any kind of evets th...
Q: For this equation. Daniel and his family recently moved to California. Daniel wants to know which am...
A: given,
Q: Please try to solve in 30 minute A queueing system has an arrival rate of 45 visitors per hour (stan...
A: Given, Service rate s = 35 visitor per hour Standard deviation Ss = 20
Q: (d) A company has three factories. Each factory produces three different products (A, Band C). Facto...
A:
Q: Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBust...
A: Objective Functions and Constraints: Based on the given details, the objective funct...
Q: 1) To order less than 2,000 the vendor quotes S1.80 per piece. Orders between 2001 to 5,000 are $1.6...
A: 1. Given, Annual demand, d= 15000 pieces Ordering cost, o =$200 Inventory holding cost perc...
Q: (Use an excel sheet to show formulas used)
A: (a) Volume break even= Fixed cost/(revenue per unit- variable cost per unit) (b) Profit= Revenue*qua...
Q: Elucidate the importance of supply chain management in healthcare
A: In the healthcare industry, there is a pressing demand for better supply chain management. COVID-19 ...
Q: Max 1W + 1.25M s.t. 5W + 7M 3W + 1M 2W + 2M W, M 20 S 4,400 S 2,240 S 1,600 oz of whole tomatoes oz ...
A: Objective of the problem is to maximize profit. Each jar is of 10 ounces. Western Food Salsa (W)...
Q: can you give in details ,importance of work measurement
A: Work measurement is related to determining the time that is required to perform the work of the unit...
Q: A system operates for 11 consecutive hours. During this period, four failures occurred that, in tota...
A: The mean Time between Failures is the average time in which the system fails or breakdown.
Q: 13.20. Southwood Furniture Company is a U.S.-based furniture manufacturer that offshored all of its ...
A: Given: Annual Demand (D)= 715 Holding cost (H) =$1200 Ordering cost (S) =$6000
Q: In a fabric manufacturing factory, the quality control process using control charts from SPC. In an ...
A: Given samples-
Q: imple flow chart for applying a job
A: A job request is a arrangement that records factual education, communication information & profe...
Q: Set up the objective function and enumerate all the constraints, Define the decision variables of th...
A: After adding the information given in the question description, the table will be as follows. Total...
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
- The sales manager like to have seasonal prices discounted from the regular sales price. He would like to change all his product prices at the same time whenever the season changes. What is the most efficient way to do this? Create a price list called 'regular sales price list' to list the regular sales prices. Whenever Manager wants to have a seasonal price list, he will use the 'regular sales price list' as the base price list and enter a discount factor. Create a price list for the regular sales price. Create a hierarchy called 'seasonal prices' which will be based on the regular sales price list and will give time-based discounts for the season based on a factor Manager enters. Create a price list which will contain the regular sales prices. Define period and volume discounts for the seasonal prices which will contain both the validity periods for the discounts and a factor to calculate the discounts for all items. Create a price list called 'regular sales price list' to list the…If Exxon uses FIFO for its inventory valuation, calculate the cost of ending inventory and cost of goods sold if ending inventory is 110 barrels of crude oil. Beginning inventory and purchases Barrels Barrel cost Total cost Beginning inventory: Jan 1 129 $ 96 $ 12,384 March 1 54 102 5,508 June 1 69 99 6,831 September 1 79 91 7,189 December 1 54 104 5,616 385 $ 37,528 Cost of ending inventory Cost of goods soldlink of PDF : https://docdro.id/psUSO2n https://docdro.id/KV8USNQ question : 1. According to Weele, why should we measure the purchasing function? 2. According to Weele, what elements in the purchasing function should we measure? 3. According to Weele, the items that we measure determines the role of the purchasing function. List these roles, and show the mapping. 4. According to Simpson and et.al, why should we measure the performance of our suppliers? 5. According to Simpson and et. al, what are the characteristics of our suppliers should we measure? List these down in terms of evaluative criteria and its details.
- 1. You are starting a business selling ferrets. • You need a pen and supplies which will cost you $100. Also, each ferret costs $10 each. Fill the table for cost. You will sell the ferrets for $15 each. Fill the table for Money. Plot and graph both lines for Cost and Money Use the provided paper (looks like this), take a picture and submit. 400 Money ($) Cost 0. 10 10 200 20 20 30 30 40 40 50 50 10 20 30 40 50 Edit View Insert Format Tools Table 12pt v Paragraph v BIUA v 8888- Ferrets Bought 888- Ferrets sold Money ($)Use a single excel file with formulas within answer cells. Show formulas for how to get the answer. The ticketing office at a professional sports venue has noticed that ticket sales seem to fluctuate. The manager wants to introduce the strategy of demand-pricing in order to maximize attendance and therefor revenue. Based on historical sales, manager wonders if there is a connection between winning percentage (in decimal form) of the team and attendance (seats). Attendance (seats) Winning Percentage (decimal form) 78,000 0.6 89,000 0.67 93,000 0.7 59,000 0.5 65,000 0.55 97,000 0.9 86,000 0.6 75,000 0.55 91,000 0.8 61,000 0.52 What is the forecasted attendance if winning percentage is 0.67?The lease cost for a specialized highway design software package is estimated to be $13,000 for each of years 1, 2, and 3 (future dollars). (a) Calculate the CV amount today (year 0) of each future cost estimate at the inflation rate of 6% per year. (b) Develop a spreadsheet and graph for inflation rates of 3%, 6%, and 8% per year that show the CV today.
- Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At the end of the 1st week of December, she was able to disposed 500 perfumes at Php150 each. Of these 500 units, she gave a total of 20 giveaways. The total cost for each perfume is Php120. Determine Camille’s net sales volume. *4802075500 Let’s say that last November you have sold 10,000 pieces of chrysanthemum at 25 pesos each. For every piece sold, you will be given a commission of 10%. How much was your total commission? *225,00025,00010,0002.50250,000The Concept of Present Value (PV) and Future Value (FV) involve compounding and discounting. Using Amazon provide real example and discuss how each is used and their importance.you are serving a wine special: a 5 ounce glass of wine for $7.00. you purchase 2 cases of 750-ml bottles of wine (12 per case) for $215.76. At the end of the week 3 bottles remain. what is the percent of wine that remains, how many glasses of wine did you sell and what is the beverage cost percent?
- A company manufactures a single product. Budget and standard costs details for the next year include; selling price per unit; $24 variable production cost per unit; $8.60 fixed production cost; $650,000 fixed selling and distribution costs; $230,400 sales commission 5% of selling price sales 90,000 units REQUIRED Calculate the break-even point in units Calculate the percentage by which the budgeted sales can fall before the company begins to make a loss. The Marketing Manager has suggested that the selling price per unit can be increased to $25 if the sales commission is increased to 8% of selling price and a further $10,000 is spent on advertising. calculate the revised break-even point based on the marketing manager's suggestionFinal Price and Profit Equations This exercise will help you identify and understand what goes into determining both the final price for a purchased product as well as the equation for the profit on a product. Among all marketing and operations factors in a business firm, price has a unique role. It is the place where all other business decisions come together. The price must be "right"—in the sense that customers must be willing to pay it; it must generate enough sales dollars to pay for the cost of developing, producing, and marketing the product; and it must earn a profit for the company. Small changes in price can have big effects on both the number of units sold and company profit. Read the case below and answer the questions that follow. You are shopping for a new printer to take back to college with you. You decide on the PIXMA iP100 due to its superior photo print quality and are now looking for the best price. Different stores have different deals, plus the…Having a flat battery in a mobile phone, tablet or laptop is exceedingly frustrating for anyone. But so is being bored and having nothing to do with your hands. Or needing to make a decision. The solution to all these is the fidget charger. Not only does it provide the cables necessary to charge any device,but it also lets you fidget and make decisions!The estimated selling price is $40and it comes in a range of colours. 1.A phone charger. As a charger, it works on all devices, thus it is able to charge any device. Not only can one phone be used to charge another phone, it can also be used to charge a range of devices including smart watches, earbuds,phones and speakers.This way it can replace all other charging cables. The cable is about 20cm long and weighs 45g. When buying the fidget charger,the purchaser needs to choose between a lightning or a micro-usb charge ras it works on both Android and ios operating systems. 2.As a fidget deviceThe fidgeting part enables your brand to work…