Markets related software and software-support services

Assignment Help Operation Management
Reference no: EM132224332

CompUSA Inc. sells computer hardware. It also markets related software and software-support services. The company prepares annual forecasts for sales, of which the first six months of 2019 are given below. In a typical month, total sales are broken down as follows: cash sales, 30%; VISA® credit card sales, 65%; and 5% open account (the company’s own charge accounts). For budgeting purposes, assume that cash sales plus bank credit card sales are received in the month of sale; bank credit card sales are subject to a 3% processing fee, which is deducted daily at the time of deposit into CompUSA’s cash account with the bank. Cash receipts from collection of accounts receivable typically occur as follows: 26% in the month of sale, 50% in the month following the month of sale, and 21% in the second month following the month of sale. The remaining receivables generally turn out to be uncollectible. CompUSA’s month-end inventory requirements for computer hardware units are 30% of the following month’s estimated sales. A one-month lead time is required for delivery from the hardware distributor. Thus, orders for computer hardware units are generally placed by CompUSA on the 25th of each month to ensure availability in the store on the first day of the month needed. These units are purchased on credit, under the following terms: n/45, measured from the time the units are delivered to CompUSA. Assume that CompUSA takes the maximum amount of time to pay its invoices. On average, the purchase price for hardware units runs 60% of selling price. CompUSA Inc. Forecasted Sales (units and dollars) January–June 2019 Number of Units Hardware Sales Software/ Support Sales Total Revenue January 134 $ 375,200 $ 147,000 $ 522,200 February 144 403,200 167,000 570,200 March 100 280,000 137,000 417,000 April 90 252,000 132,000 384,000 May 124 347,200 157,000 504,200 June 134 375,200 147,000 522,200 Totals 726 $ 2,032,800 $ 887,000 $ 2,919,800 Required: 1. Calculate estimated cash receipts for April 2019. 2. The company is looking at the number of hardware units to order on January 25. a. Determine the estimated number of units to be ordered. b. Calculate the dollar cost (per unit and total) for these units. 3. Cash planning in this line of business is critical to success. Management feels that the assumption of selling price per unit ($2,800) is firm—at least for the foreseeable future. Also, it is comfortable with the 30% rate for end-of-month inventories. It is not so sure, however, about (a) the Cost of Goods Sold (CGS) rate (because of the state of flux in the supplier market) and (b) the level of predicted sales in March 2019. Discussions with marketing and purchasing suggest that three outcomes are possible for each of these two variables, as follows: Outcome March Sales CGS% Optimistic 110 units 55 % Expected 100 units 60 Pessimistic 90 units 65 The preceding outcomes are assumed to be independent, which means that there are nine possible combinations (3 × 3). You are asked to conduct a sensitivity analysis to determine the range of possible cash outflows for April 10, under different combinations of the above. Assume, for simplicity, that sales volume for April is fixed. Complete the following table:

Reference no: EM132224332

Questions Cloud

How does the company capture value from you in return : What value do you get from the relationship, and how does the company capture value from you in return?
Franchise footlocker project : Franchise "footlocker" project.
Three-bedroom apartments that need to be remodeled : In the Database sheet, enter conditions in the criteria range for unoccupied two- and three-bedroom apartments that need to be remodeled.
What is the purpose of project network diagram : What is the purpose of a project network diagram? List and describe three different supply chain strategies.
Markets related software and software-support services : CompUSA Inc. sells computer hardware. It also markets related software and software-support services.
Regarding eight key supply chain processes : Describe as much as you can regarding the eight key supply chain processes, and how each one of these functions.
Briefly describe seven leadership concepts : Briefly describe seven leadership concepts that you can apply to your leadership career. Be as specific as you can.
What are the challenges facing supply manager in : Where in the supply process is there the greatest opportunity to add value and why? What are the challenges facing a supply manager in
How can a simple rumor trigger communication crisis : Why / How can a simple rumor trigger a communication crisis? Discuss. Provide examples.

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd