Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CompUSA Incorporated sells computer hardware. It also markets related software and software - support services. The company prepares annual forecasts for sales, which are given

CompUSA Incorporated sells computer hardware. It also markets related software and software-support services. The company prepares annual forecasts for sales, which 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 companys 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 CompUSAs cash account with the bank. Cash receipts from collection of accounts receivable typically occur as follows: 21% in the month of sale, 50% in the month following the month of sale, and 26% in the second month following the month of sale. The remaining receivables generally turn out to be uncollectible.
CompUSAs month-end inventory requirements for computer hardware units are 30% of the following months 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 Incorporated
Forecasted Sales (units and dollars)
JanuaryDecember,2025
Hardware Sales (Units) Hardware Revenue Software or Support Services Revenue Total Revenue
January 122 $ 378,200 $ 141,000 $ 519,200
February 132409,200161,000570,200
March 100310,000131,000441,000
April 90279,000126,000405,000
May 112347,200151,000498,200
June 122378,200141,000519,200
July 82254,200101,000355,200
August 152471,200196,000667,200
September 102316,200116,000432,200
October 82254,200101,000355,200
November 77238,70091,000329,700
December 97300,700121,000421,700
Totals 1,270 $ 3,937,000 $ 1,577,000 $ 5,514,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: kieso, weygandt and warfield.

14th Edition

9780470587232, 470587288, 470587237, 978-0470587287

More Books

Students also viewed these Accounting questions