please help with 3 question in detail on excel. thank you CASE STUDY The Sourcing Decision...
Please answer questions using Microsoft excel, and please show
formulas. Thank you.
School of Business BUS 476-Operations Management Dr. Enrique G. Zapatero, Professor Homework #8-Aggregate Planning Instructions: Use MS Excel to produce the computations to support your answers to ProblemsI, and I. Problem I: A production manager needs to develop a production schedule to meet the following demand Period Demand 600 600 800 1000 1200 600 2 Productions costs are as follows: (a) regular time: $3 per unit. (b) over-time:...
Please provide solution through excel with formulas please.
Thank You!
3. (25 points) In order to be ready for the upcoming holiday season, BTS Toy Company (BTC) designed a new doll called The V that teaches children how to dance. The fixed cost to produce the doll is $105,000. The variable cost, which includes material, labor, and shipping costs, is $35 per doll. During the holiday selling season, FTC will sell the dolls for $45 each. If BTC overproduces the...
Please Help with this Case Study and answer corresponding questions to the case Below with examples of how to achieve said answers. In May 2013, Rebecca Young completed her MBA and moved to Toronto for a new job in investment banking. There, she rented a spacious, two-bedroom condominium for $3,000 per month, which included parking but not utilities or cable television. In July 2014, the virtually identical unit next door became available for sale with an asking price of $620,000,...
Please help with these case questions. Thank you Balagny Clothing Company Inc. is a major apparel manufacturer in the United States. It makes men's, women's, and children's casual wear such as denim jeans, cotton slacks, skirts, and sweaters. Balagny Clothing has taken the low-cost provider strategy and is constantly trying to find ways to cut costs and maintain its 4 percent profit margin while maintaining a competitive advantage over its major competitors. Because direct labor makes up approximately 65 percent...
Case Study 3: Specialty Toys Specialty Toys, Inc., sells a variety of new and innovative children's toys. Management learned that the preholiday season is the best time to introduce a new toy, because many families use this time to look for new ideas for December holiday gifts. When Specialty discovers a new toy with good market potential, it chooses an October market entry date. In order to get toys in its stores by October, Specialty places one-time orders with its...
Case Study: Heinkel-Fishbein, Inc. Heinkel-Fishbein is a large importer and distributor of robotic toys. The toys are stored in the warehouse and are shipped to a several large retail chains at a standard price.. There is almost no possibility in the near future of changing the prices at which Heinkel-Fishbein supplies the retail stores. Thus there is a need to increase profits by managing total costs. Considering one toy, identified as SKU 2600, the process consists of receiving the boxes...
Case assignments must be completed with a written 2-page study on the assigned case questions in the textbook. The format requested for these assignments is based on elaborating and including two basic parts in the essay: 1) in a bullet presentation style (one phrase each bullet), list a summary of the key issues, situations, problems, opportunities and threats you may identify as relevant; 2) answer all the questions listed in each case in two or three sound paragraphs. Use the...
Marketing Question Please read the following article and answer this question: Do you think Apple's connection to their supplier impacts their relationship with their consumer? Apple, Foxconn Broke a Chinese Labor Law to Build Latest iPhones Apple Inc. and manufacturing partner Foxconn violated a Chinese labor rule by using too many temporary staff in the world’s largest iPhone factory, the companies confirmed following a report that also alleged harsh working conditions. The claims came from China Labor Watch, which issued...
Normal No Spacing CASE STUDY: Yaosba Leans on IS to Stay Competitive More than ever before, Chinese retailers are facing local competition from foreign companies. China's highly regulated economy has insulated businesses from competition. Now that China is loosening its regulations in an effort to benefit from international trade, its own businesses must work harder to become more efficlent and effective and keep customers retailers. It sells other fine merchandise. One of its largest retail stores occupies 215,000 square feet...
Please help! especially part c,d,e.
part a answer:
Excel = Norm.Inv (0.889, 2500, 400)
= 2989
part b answer:
Excel
= Norm.inv (0.95, 2500, 400)
= 3158
ABC Sportswear company designs and sells wetsuits to the U.S. market. The designs of the wetsuits are updated each year. The process for updating the design typically starts in January the year before the designs are to be released. At this time, the purchasing, design, and sales departments have a two-day meeting to...