Question

In: Accounting

Rita Jekyll operates a sales booth in computer software trade shows, selling an accounting software package,...

Rita Jekyll operates a sales booth in computer software trade shows, selling an accounting software package, Abacus. She purchases the package from a software company for $165 each. Booth space at the convention hall costs $13,000 per show.

Required

a. Sales at past trade shows have ranged between 400 and 600 software packages per show. Determine the average cost of sales per unit if Ms. Jekyll sells 400, 450, 500, 550, or 600 units of Abacus at a trade show. Use the following chart to organize your answer. Is the cost of booth space fixed or variable?

b. If Ms. Jekyll wants to earn a $50 profit on each package of software she sells at a trade show, what price must she charge at sales volumes of 400, 450, 500, 550, or 600 units?

c. Record the total cost of booth space if Ms. Jekyll attends three, four, five, six, or seven trade shows. Is the cost of booth space fixed or variable relative to the number of shows attended?

d. Ms. Jekyll provides decorative shopping bags to customers who purchase software packages. Some customers take the bags; others do not. Some customers stuff more than one software package into a single bag. The number of bags varies in relation to the number of units sold, but the relationship is not proportional. Assume that Ms. Jekyll uses $30 of bags for every 58 software packages sold. What is the additional cost per unit sold? Is the cost fixed or variable?

Solutions

Expert Solution

Solution a:

Computation of average cost of sales per unit
Particulars 400 units 450 units 500 units 550 units 600 units
Purchase cost ($165*nos of units) 66000 74250 82500 90750 99000
Booth space hall cost $13,000.00 $13,000.00 $13,000.00 $13,000.00 $13,000.00
Total cost $79,000.00 $87,250.00 $95,500.00 $103,750.00 $112,000.00
Nos of software sold $400.00 $450.00 $500.00 $550.00 $600.00
Average cost of sales per unit $197.50 $193.89 $191.00 $188.64 $186.67

Cost of booth space is a fixed cost irrespective of number of software sold.

Solution b:

Computation of average cost of sales per unit
Particulars 400 units 450 units 500 units 550 units 600 units
Average cost of sales per unit $197.50 $193.89 $191.00 $188.64 $186.67
Target profit per software $50.00 $50.00 $50.00 $50.00 $50.00
Price to be charge per software $247.50 $243.89 $241.00 $238.64 $236.67

Solution c:

Computation of Total cost of booth space
Particulars 3 shows 4 shows 5 shows 6 shows 7 shows
Cost per booth space $13,000.00 $13,000.00 $13,000.00 $13,000.00 $13,000.00
Nos of booth space 3 4 5 6 7
Total cost of booth space $39,000.00 $52,000.00 $65,000.00 $78,000.00 $91,000.00

Cost of booth space is variable relative to the number of shows attended.

Solution d:

Cost fo decorative bags per 58 software = $30

Hence additional cost per unit sold = $30 /58 = $0.52 per unit

The cost of decorative bag is batch level cost that varies with number of batches. It is also to be called as step fixed cost.


Related Solutions

A small accounting firm is considering the purchase of a computer software package that would greatly...
A small accounting firm is considering the purchase of a computer software package that would greatly reduce the amount of time needed to prepare tax forms. The software costs $2250 and this expense will be incurred immediately. The firm estimates that it will save $525 at the end of each year beginning in one year for 4 consecutive years, and also save $1444 in year 5. What is the payback on the computer package?
A small accounting firm is considering the purchase of a computer software package that would greatly...
A small accounting firm is considering the purchase of a computer software package that would greatly reduce the amount of time needed to prepare tax forms. The software costs $2400 and this expense will be incurred immediately. The firm estimates that it will save $650 at the end of each year beginning in one year for 7 consecutive years, and also save $1788 in year 8. What is the payback on the computer package?
Big Red Computer Sales sold to Little Red Insurance Co. The following package. Initial software package...
Big Red Computer Sales sold to Little Red Insurance Co. The following package. Initial software package for         100,000 Training                                     300,000 Updates                                       50,000 Terms of the sale include initial down payment of 200,000 on date of sale of 1/1/04 and balance due 1/1/05. Software package is to be delivered and installed when down payment is made. Training is to incur over first two years and update to occur at end of first year. Prepare journal entries.
Problem 1 SG operates a booth at a local mall, selling watches. Current monthly sales revenue...
Problem 1 SG operates a booth at a local mall, selling watches. Current monthly sales revenue is $24,000 with total variable costs (wholesale cost of watches) of $9,000. SG currently pays $2,000 a month to rent the space and pays two full-time employees to each work 160 hours a month at $15 per hour. The manager is paid a monthly salary of $4,000. Required (Show your work): Calculate how much sales revenue SG needs to break even (10 points) If...
Problem 1 SG operates a booth at a local mall, selling watches. Current monthly sales revenue...
Problem 1 SG operates a booth at a local mall, selling watches. Current monthly sales revenue is $24,000 with total variable costs (wholesale cost of watches) of $9,000. SG currently pays $2,000 a month to rent the space and pays two full-time employees to each work 160 hours a month at $15 per hour. The manager is paid a monthly salary of $4,000. 1.Calculate how much sales revenue SG needs to break even. 2.If SG wants to earn an operating...
Software Sales A software company sells three packages, Package A, Package B, and Package C, which...
Software Sales A software company sells three packages, Package A, Package B, and Package C, which retail for $99, $199, and $299, respectively. Quantity discounts are given according to the following table: Quantity Discount 10 through 19 20% ,20 through 49 30% ,50 through 99 40% ,100 or more 50% . Create a C++ program that allows the user to enter the number of units sold for each software package. The application should calculate and display the order amounts and...
An airline wants to select a computer software package for its reservation system. Four software packages...
An airline wants to select a computer software package for its reservation system. Four software packages (1, 2, 3, and 4) are commercially available. The airline will choose the package that bumps as few passengers, on the average, as possible during a month. An experiment is set up in which each package is used to make reservations for 5 randomly selected weeks. (A total of 20 weeks was included in the experiment.) The number of passengers bumped each week is...
Task #1 – Software Sales A software company sells a package that retails for $99. Quantity...
Task #1 – Software Sales A software company sells a package that retails for $99. Quantity discounts are given according to the following: Quantity Discount 1 - 9 NO DISCOUNT 10 – 19 20% 20 – 49 30% 50 – 99 40% 100 or more 50% Your program calculates the final purchase price of the software packages based on the quantity purchased. If a value of 0 or less (a negative number) is entered, display the message “Invalid Quantity” and...
Computer Nerds, Inc., is planning a project to develop a commercial software package for PC’s. They...
Computer Nerds, Inc., is planning a project to develop a commercial software package for PC’s. They have come up with the following list of activities, times and precedence relationships.                                                                                           Immediate             Activity Time Symbol           Activity Description                                    Predecessors              (weeks)             P           Perform market survey                                        ––                         3            D            Design graphic icons                                          P                           4            F             Develop flow chart                                             P                           2            S             Design input/output screens                                D, F                      6            U            Code Module 1                                                  F                           5            V            Code...
this is in excel VB8 Program 2: Software Sales A software company sells three packages, Package...
this is in excel VB8 Program 2: Software Sales A software company sells three packages, Package A, Package B, and Package C, which retail for $99, $199, and $299, respectively. Quantity discounts are given according to the following table: Quantity Discount 10 through 19 20% 20 through 49 30% 50 through 99 40% 100 or more 50% Create an application that allows the user to enter the number of units sold for each software package. The application should calculate and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT