Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Joel Deaine, CEO of Deaine Enterprises Incorporated (DEI), is considering a special offer to manufacture a new line of women’s clothing for a large department store chain. DEI has specialized in designer women’s clothing sold in small, upscale retail clothing stores throughout the country. To protect the very elite brand image, DEI has not sold clothing to large department stores. The current offer, however, might be too good to turn down. The department store is willing to commit to a large order, which would be very profitable to DEI, and the order would be renewed automatically for two more years, presumably to continue after that point.
Required:
Determine Joel’s competitive strategy (cost leadership or differentiation) and use this strategy to analyze the choice Joel faces.
Joel Deaine, CEO of Deaine Enterprises Incorporated (DEI), is considering a special offer to manufacture a new line of women’s clothing for a large department store chain. DEI has specialized in designer women’s clothing sold in small, upscale retail clothing stores throughout the country. To protect the very elite brand image, DEI has not sold clothing to large department stores. The current offer, however, might be too good to turn down. The department store is willing to commit to a large order, which would be very profitable to DEI, and the order would be renewed automatically for two more years, presumably to continue after that point.
Required:
Explain two of the implementation tools covered in this chapter that Joel can use to implement his strategy.
D’Unique Enterprise, a company that manufactures hair growth oil is preparing for its upcoming financial year (2021). D’Unique’ is seeking a loan from JNT Bank to purchase equipment that will be used to package the oils in anticipation of sales. The loans officer at the bank is requesting the company’s upcoming financial year’s budget to assess their cash position to repay the loan
A. Sales/Collection
Sales unit in the fourth quarter of 2020 will be 2500 units and is expected to increase by 500 units over each quarter in 2021. Selling price is $60 per unit.
All sales are on account. Management expects future sales collection to follow past experiences. Customers pay 60% in the quarter of sales and 40% in the quarter following sales. Accounts receivable for December 31, 2020 is expected to be $60,000.
B. Production
To reduce the risk of a stock-out or idle time, D’Unique Co. has maintained an ending inventory policy of 20% of the following quarter’s sales unit.
C.…
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.arrow_forward3. Main Street Cinema is a single-screen movie theater in a residential area. Main Street Cinema is a licensed exhibitor of Mega Pictures Distribution Company, meaning that it receives all its movies from and pays all rental fees to this larger corporation, as per the license agreement. Otherwise, Main Street Cinema is a small business that spends a considerable amount of money each year purchasing a wide variety of products from suppliers. Last year's spend analysis revealed the following: (Noteshaper Scenario #16) Purchasing Categories Daily Janitorial Services Upholstery and carpet cleaning Soft drinks Popcorn and Candy Toilet Paper & liquid soap (bathroom) Annual Expenditure $83,000 $28,000 $25,000 $33,000 $750arrow_forwardPhoton Technologies, Inc., a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacturer to produce three models of lithium-ion battery packs for a new line of phones. The contract calls for the following. Battery Pack Production Quantity PT-100 202,000 PT-200 102,000 PT-300 149,000 Photon Technologies can manufacture the battery packs at manufacturing plants located in the Philippines and Mexico. The unit cost of the battery packs differs at the two plants because of differences in production equipment and wage rates. The unit costs for each battery pack at each manufacturing plant are as follows. Product Philippines Mexico PT-100 $0.95 $0.98 PT-200 $0.98 $1.06 PT-300 $1.34 $1.15 The PT-100 and PT-200 battery packs are produced using similar production equipment available at both plants. However, each plant has a limited capacity for the total number of PT-100 and PT-200 battery packs produced. The combined PT-100 and…arrow_forward
- Photon Technologies, Inc., a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacturer to produce three models of lithium-ion battery packs for a new line of phones. The contract calls for the following. Battery Pack Production Quantity PT-100 202,000 PT-200 102,000 PT-300 149,000 Photon Technologies can manufacture the battery packs at manufacturing plants located in the Philippines and Mexico. The unit cost of the battery packs differs at the two plants because of differences in production equipment and wage rates. The unit costs for each battery pack at each manufacturing plant are as follows. Product Philippines Mexico PT-100 $0.95 $0.98 PT-200 $0.98 $1.06 PT-300 $1.34 $1.15 The PT-100 and PT-200 battery packs are produced using similar production equipment available at both plants. However, each plant has a limited capacity for the total number of PT-100 and PT-200 battery packs produced. The combined PT-100 and…arrow_forwardPhoton Technologies, Inc., a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacturer to produce three models of lithium-ion battery packs for a new line of phones. The contract calls for the following: Battery Pack Production Quantity PT-100 200,000 PT-200 100,000 PT-300 150,000 Photon Technologies can manufacture the battery packs at manufacturing plants located in the Philippines and Mexico. The unit cost of the battery packs differs at the two plants because of differences in production equipment and wage rates. The unit costs for each battery pack at each manufacturing plant are as follows: Plant Product Philippines Mexico PT-100 $0.95 $0.98 PT-200 $0.98 $1.06 PT-300 $1.34 $1.15 The PT-100 and PT-200 battery packs are produced using similar production equipment available at both plants. However, each plant has a limited capacity for the total number of PT-100 and PT-200 battery packs produced. The…arrow_forwardSamoto Limited (SL) relies on an external supplier for production capacity. In order to gain access to a certain level of production capacity, SL will have to commit to an annual contract before the start of the operating period. The contract will stipulate the production capacity entitlement of SL. SL has a choice of three contracts: Contract Mega, Contract Upper, and Contract Soso. Regardless of the choice of contract, the company will be subject to three states of nature: high demand, medium demand and low demand. The net profits generated by each of the contracts under the three states of nature are as follows: Net profit (£000) High demand Medium demand Low demand Contract Mega Contract Upper Contract Soso 20,000 17,000 16,500 15,500 16,000 15,000 11,000 12,000 13,000 The probabilities of the states of nature are as follows: High demand Medium demand Low demand Probability 25% 45% 30% Required: a) Determine the choice of contract using the regret criterion.arrow_forward
- Sachs Brands's defined benefit pension plan specifies annual retirement benefits equal to 1.5% × service years × final year's salary, payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of 2007 and is expected to retire at the end of 2041 after 35 years' service. Her retirement is expected to span 18 years. Davenport's salary is $83,000 at the end of 2021 and the company's actuary projects her salary to be $245,000 at retirement. The actuary's discount rate is 9%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) At the beginning of 2022, the pension formula was amended to: 1.60% × Service years × Final year's salary The amendment was made retroactive to apply the increased benefits to prior service years. Required: 1. What is the company's prior service cost at the beginning of 2022 with respect to Davenport after the amendment described above?2. Since the amendment occurred at…arrow_forwardn September 2012, a 260,000 square foot Costco anchored shopping center was acquired in San Mateo, California for $36 million with a $26 million fully amortizing first mortgage loan from Union Bank. By 2018, the property had substantially appreciated in value and was worth $72 million and the owner wanted to access part or all of the increased equity value while paying little or no current taxes. The owner might: Refinance the property with a larger loan All these answers are correct Sell the property under an installment sale contract Trade the property for a property whose sale price is more than $54 million under Section 1031 of the Internal Revenue Codearrow_forwardOn January 1, Jack signed a contract with AT &T for his mobile phone services. The contract includes three lines with a $120 fixed payment each month plus $15 per gigabit if the data usage is more than 9 gigabits. On March 1, Jack wants to add one more phone line to the existed contract, and the payment becomes $150 fixed payment each month plus $15 per gigabit if the data usage is more than 12 gigabits. Is this change a contract modification? Please use one sentence to explain why?arrow_forward
- Keegan and Hossein founded Apadana Holdings, which operates under the name Mica Paint and Hardware. Their primary establishment, Mica Parktown North, was constructed from scratch and launched on August 25, 2021, with the purpose of catering to the community members and construction professionals in the vicinity. The business recently purchased an additional store in Emmarentia and commenced operations six months ago. The duo intends to broaden their operations to Bryanston within the time frames of 2024 and 2025. The initial capital investment for the establishment of Mica Parktown North, the group's first store, was R4.5 million. However, on the opening day of 2021, this amount suddenly increased to R6.5 million. After experiencing an initial decrease in the number of people visiting the store when it first opened, there has been a consistent and noticeable growth in foot traffic. As a result, the store is now becoming the preferred brand for local residents. The store now handles an…arrow_forwardDonald has a bank account at Republic Live Bank which is heavily overdrawn. The bank sent out numerous correspondences to Donald about the overdraft limit and the need for Donald to meet with them and discuss repayment. Donald in his usual way ignored the bank’s request. Mr Big, Manager of Republic Live Bank is expected to meet with Donald and negotiate how they will reduce the overdraft amounts. During his review of Donald’s drawdowns over the last few months, he noticed that a cheque was drawn and the sums paid to a known drug dealer. He telephoned Donald’s home to set up a meeting and his maid answered the phone. Mr Big proceeded to explain to the maid that Donald’s account is heavily overdrawn and during the conversation, pointed out that he saw a transaction whereby Donald paid a known Drug dealer. Donald’s maid became extremely interested in this new revelation, because she had it in for Donald for cutting her salary, due to her damaging his oriental carpet in the living room.…arrow_forwardBrooke Bentley, a student in business administration, is trying to decide which management science course to take next quarter-I, II, or III. “Steamboat" Fulton, " Death" Ray, and "Sadistic" Scott are the three management science professors who teach the courses. Brooke does not know who will teach what course. Brooke can expect a different grade in each of the courses, depending on who teaches it next quarter, as shown in the following payoff table: Professor Course Fulton Ray Scott I D II C В F III F A C Determine the best course to take next quarter, using the following criteria. Maximax b. Maximinarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,