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
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Tip Top Toys is a relatively small division of Worldwide Enterprises. Worldwide has nine other divisions, which include insurance, health-care products, and financial planning services, to name a few. The corporate marketing director for Worldwide has requested Tip Top’s customer shopping data to target people who might be likely to purchase items or services from other Worldwide divisions. The database manager is not totally comfortable with this and pointed out Tip Top’s web privacy policy, which states “Tip Top Toys, a division of Worldwide Enterprises, will not share personal data with other companies without a customer’s consent.”
The marketing director replied that the statement only applies to outside companies— not other Worldwide divisions. He said he checked with the corporate legal department, and they agreed. The database manager replied, “Even if it is legally OK, it’s not the right thing to do. Many people take our statement to mean that their data does not leave Tip Top.…
Marcus is a computer engineer who has recently developed an app which helps userskeep track of medical information, doctor’s appointments, and prescriptions.Information about the user is stored in this app, including what prescriptions they aretaking and how frequently they schedule doctor’s appointments. As the developers ofthe app, Marcus and his company have access to this information.The marketing department requests Marcus supply them with customer-specificinformation so they can better target ads and app suggestions to the users. Marcusunderstands that he is part of a company, but also feels that the privacy of the appusers should be protected. Additionally, Marcus feels that as an engineer, he should beresponsible to those who use his technology.Note that Marcus is not a healthcare provider, nor does he work for a medicalfacility. As you plan your answer, consider the current healthcare and legal climatesand concerns that may exist relating to individuals' healthcare choices.
1.…
Andy’s Bicycle Company (ABC) has the hottest new product on the upscale toy market—boys’ and girls’ bikes in bright fashion colors, with oversize hubs and axles; shell design safety tires; strong padded frames; chrome-plated chains, brackets, and valves; and non-slip handlebars. Due to the seller’s market for high-quality toys for the newest baby boomers, ABC can sell all the bicycles it manufactures at the following prices: boys’ bikes, $220; girls’ bikes, $175. This is the price payable to ABC at its Orlando plant. The firm’s accountant, V. R. Dondeti, has determined that direct labor costs will be 45% of the price that ABC receives for the boys’ model and 40% of the price received for the girls’ model. Production costs, other than labor but excluding painting and packaging, are $44 per boys’ bicycle and $30 per girls’ bicycle. Painting and packaging are $20 per bike, regardless of model. The Orlando plant’s overall production capacity is 390 bicycles per day. Each boys’…
Knowledge Booster
Similar questions
- A cosmetic manufacturer wants to understand why users shop online versus in store, and how they might take better advantage of the online channel; the manufacturer wants to make improvements to the company’s website. The manufacturer also wants to find out why Nordstrom.com (a competitor’s website) appeals to cosmetic consumers versus other websites. The cosmetic manufacturer also wants to find ways to improve consumers’ in-store experience. Further, the manufacturer wants to produce a three (3) month sales forecast based on the data produced from the research. Objectives: Why users shop online versus in store How to take advantage of the online channel How to improve the company’s website Why does Nordstrom.com (their competitor) appeal to cosmetic consumers versus other websites. Ways to improve consumers’ in-store experience Requireed: Produce fictitious findings, chart and dat analysis that relate back to the objectives.arrow_forwardBorn in 1954, the Sarihusada Generasi Mahardhika Company (Sarihusada) is known as a strong player in the dairy business. SGM offers mother and child products to support their fulfillment of nutrition and health. Naturally, in a survey on the e-commerce market, SGM is a strong player in the market for baby milk. Sarihusada, which has a factory in Yogyakarta, has also worked on the e-commerce market for its baby milk products. Its products are available in e-commerce in Indonesia, such as Orami, Tokopedia, Shopee, Bukalapak, JD.ID, Blibli, and Lazada SGM entered e-commerce since 2016. “The products we offer in the e-commerce market are of the same quality as those in conventional markets. However, in e-commerce we offer a different shopping experience, because consumers can enjoy the convenience of shopping anywhere and anytime while getting more educational information," said Widianto Juwono, Sales Director of Danone Specialized Nutrition Indonesia who manages the marketing of SGM…arrow_forwardBorn in 1954, the Sarihusada Generasi Mahardhika Company (Sarihusada) is known as a strong player in the dairy business. SGM offers mother and child products to support their fulfillment of nutrition and health. Naturally, in a survey on the e-commerce market, SGM is a strong player in the market for baby milk. Sarihusada, which has a factory in Yogyakarta, has also worked on the e-commerce market for its baby milk products. Its products are available in e-commerce in Indonesia, such as Orami, Tokopedia, Shopee, Bukalapak, JD.ID, Blibli, and Lazada SGM entered e-commerce since 2016. “The products we offer in the e-commerce market are of the same quality as those in conventional markets. However, in e-commerce we offer a different shopping experience, because consumers can enjoy the convenience of shopping anywhere and anytime while getting more educational information," said Widianto Juwono, Sales Director of Danone Specialized Nutrition Indonesia who manages the marketing of SGM…arrow_forward
- Read the statements below and answer all the five questions that follow:Materials management includes the job of purchasing. In any industry, purchase refers to the acquisition of necessary equipment, materials, tools, and parts. The relevance of the buying function varies depending on the industry and its size. This duty is performed by the works manager in small businesses, and by a distinct department in major manufacturing companies. As soon as a purchaser places an order he/she commits a substantial portion of the finance of the corporation which affects the working capital and cash flow position. He/she is a highly responsible individual who interacts with many salespeople and can thus be deemed to have contributed to the company's public relations efforts. Source: https://businesstech.co.za/news/business/220551/these-are-the-5-biggest-retailers-in-south-africa/ You are managing the purchasing department at Walmart's Cambridge Foods in South Africa. Critically discuss the…arrow_forwardPLS HELP ASAParrow_forwardThe FlyRight Aircraft Maintenance (FRAM) division of the FlyRight Company (FRC) performs all maintenance for FRC’s aircraft. Produce a data model segment that reflects the following business rules: All mechanics are FRC employees. Not all employees are mechanics. Some mechanics are specialized in engine (EN) maintenance. Some mechanics are specialized in airframe (AF) maintenance. Some mechanics are specialized in avionics (AV) maintenance. (Avionics are the electronic components of an aircraft that are used in communication and navigation.) All mechanics take periodic refresher courses to stay current in their areas of expertise. FRC tracks all courses taken by each mechanic—date, course type, certification (Y/N), and performance. FRC keeps a history of the employment of all mechanics. The history includes the date hired, date promoted, date terminated, and so on. (Note: The “and so on” component is, of course, not a real-world requirement. Instead, it has been used here to limit the…arrow_forward
- Often we read news related to the recall of several products that have been circulating in themarket. One example is what was done by PT Toyota Astra Motor (TAM) and PT AstraDaihatsu Motor (ADM) some time ago. They officially announced the recall or recall of severalproduct models. The following are excerpts of news published in Kompas related to the recallof TAM and ADM products: A few days ago, PT Toyota Astra Motor (TAM) and PTAstra Daihatsu Motor (ADM), officially announced the recall or recall of severalproduct models.The source of the problem is indicated by a malfunctioning fuel pump impeller. ForDaihatsu, there are three models that experience this problem, namely Sirion, Xenia,and Terios with a total of 97,290 units in Indonesia.For Toyota, the fuel pump problem is even wider in its lineup of units, from Rush,Avanza, Voxy, Alphard, Camry, Hilux, Corolla, Fortuner, Innova, to the C-HR. Thetotal is approximately 286,000 units.Well, it is important to know that recall is a form…arrow_forwardThe Northwoods General Store The Northwoods General Store in Vermont sells various outdoor clothing items and equipment and several food products at its modern but rustic-looking retail store. Its food products include salmon and maple syrup. The store also runs a lucrative catalog operation. One of its most popular products is maple syrup, sold in metal half-gallon cans with a picture of the store on the front. Maple syrup was one of the first products the store produced and sold, and it continues to do so. Setting up the syrup-making equipment to produce a batch of syrup costs $450. Storing the syrup for sales throughout the year is tricky because the syrup must be kept in a temperature-controlled facility. The annual cost of carrying a gallon of syrup is $15. Based on past sales data, the store has forecasted demand of 7,500 gallons of maple syrup for the coming year. The store can produce approximately 100 gallons of syrup per day during the maple syrup season, from February…arrow_forwardA sales ledger is a detailed listing of all sales made and presented in date sequence. A sales ledger can have a wealth of information, including the sale date, invoice number, customer name, items sold, sale amounts, freight charged, sales taxes, and value-added tax. Additionally, it may contain credits issued to customers that reduce sales, such as for returned products. EXPLAIN the mechanism used by the sales ledger in handling the company's credit management.arrow_forward
- On With Living (OWL) is a nonprofit organization dedicated to improving the physical and mental health of individuals age sixty-five and older. It is a local chapter of a national organization, the OWL Association, which had been in existence for nearly thirty years. Both the local chapter and the national organizational offer programs and services to help seniors stay healthy and fund research to find ways to prevent, treat, and cure diseases that affect people over sixty-five, such as Alzheimer’s disease, diabetes, and heart disease. Each local chapter is obligated to adhere to the positions of the national organization, and any modification or rejection of the national position is prohibited according to the statement of relationship signed by both parties. Any violation of this relationship agreement would result in disaffiliation from the national organization, which local chapters attempt to avoid at all costs. One position statement of the national organization took a firm…arrow_forwardJohnson and JohnsonThe company introduced various product safety, ingredient safety and product quality and safetymeasures to prevent the repetition of such an event. These measures are indicated in the sectionsthat follow:Product SafetyAs far as product safety is concerned, J&J ensures that every product that the company sells mustmeet their high standards of quality, safety and efficacy. Safety professionals at J&J companiesconduct through safety assessments as part of the detailed testing of quality, safety and effectivenessbefore any new product is introduced to the market. These professionals make assessments of eachraw material, to identify safe and effective ingredients, and the finished product, to ensure it worksthe way that it is intended to work. J&J also assesses their products after they have reached theirmarket in order to identify any safety issue that may occur.Ingredient safetyThe J&J companies buy and manufacture an array of raw materials, active…arrow_forwardJohnson and JohnsonThe company introduced various product safety, ingredient safety and product quality and safetymeasures to prevent the repetition of such an event. These measures are indicated in the sectionsthat follow:Product SafetyAs far as product safety is concerned, J&J ensures that every product that the company sells mustmeet their high standards of quality, safety and efficacy. Safety professionals at J&J companiesconduct through safety assessments as part of the detailed testing of quality, safety and effectivenessbefore any new product is introduced to the market. These professionals make assessments of eachraw material, to identify safe and effective ingredients, and the finished product, to ensure it worksthe way that it is intended to work. J&J also assesses their products after they have reached theirmarket in order to identify any safety issue that may occur.Ingredient safetyThe J&J companies buy and manufacture an array of raw materials, active…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
