Thursday, January 27, 2011
Gross Profit Analysis Part 2. Case Study
Gross Profit analysis of time sharing computer programs:
The senior system analysis of Tyrene, Inc. Bob Canedy, developed in his spare time three unique packages of computer programs: Package 1, inventory control; Package 2, sales analysis; Package 3; report preparation. After realizing their marketability, he struck out on his own, forming data-Pack Co., a computer time sharing service bureau. He rented an adequate computer and leased some data communication lines and terminals, then placed the packages on-line. Once operational, he planned to sell the use of his packages to industrial customers by the system-connect-hour, i.e., total time elapsing while the customer's terminal is directly connected to the central computer.
In the process of establishing profitable sales prices, Candey decided to project costs for the first year. Using processing information provided by the computer sales representative, he allocated the total cost to the packages as follows:
Computer Rental ($56,000) Other Common Costs ($14,000)
Package (1)
Core Requisitions (000s Bits) % of Total Core Requisitions CPU* Hrs
System Connect Hrs (2)
% of Total CPU to System Connect Hrs. Weighted Average [4 × Col. (1) - Col. (2)] - 5 Common Cost Traceable Cost Total Cost
1 80 60% 0.18 10% 50% $35,000 $10,000 $45,000
2 33 25 0.90 50 30 21,000 14,000 35,000
3 20 15 0.72 40 20 14,000 6,000 20,000
---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
Total 133 100% 1.80 100% 100% $70,000 $30,000 $100,000
====== ====== ====== ====== ====== ====== ====== ======
*Central Processing Unit
Working from expected costs, Canedy computed the desired markup for each of the packages. Since he knew that the useful lives of the programs were only a few years, he decided to recoup the investment in time that he had spent on developing the programs by using that criterion in computing a sales price, as follows:
Package Workdays Spent in Developing Programs (1)
% of Total Development Projected Sales (Hrs.) (2)
Hourly Cost (Per unit) Unit Markup
(1) × (2) Unit Sales Price Total Sales (Hrs. × Sales Price)
1 27 15% 900 $50 $7.50 $57.50 $51,750
2 108 60 1,000 35 21.00 56.00 56,000
3 45 25 500 40 10.00 50.00 25,000
----------- ----------- ----------- ----------- ----------- ----------- -----------
Total 180 100% 2,400 $132,750
======== ======== ======== ======== ======== ======== ========
After the first year of operation, Data-Pack's income statement appeared as follows:
Sales:
Package 1: 1,200 hrs. @ $53 $63,600
Package 2: 900 @ 58 52,200
Package 3: 700 @ 46 32,200
------------- $148,000
Cost of goods sold: Common Traceable Total
Package 1: $40,000 $14,000 $54,000
Package 2: 24,000 12,000 36,000
Package 3: 16,000 5,000 21,000
----------- 111,000
-------------
Operating income $37,000
======
Although the firm exceeded planned profits by $4,250, it was evident that changes in demand for the packages and changes in costs and sales prices made this gain only coincidental.
Required:
A gross profit analysis to determine the effects of the demand and fluctuating prices on sales revenue, so that a new price for the most profitable package can be established.
Solution:
Analysis of Sales Price and Sales Volume Variance
Package 1 Package 2 Package 3
Actual sales $63,600 $52,200 $32,200
Actual sales hours × budgeted unit sales price
#1: 1,200 hrs. × $57.50
69,900
50,400
35,000
------------ ------------ ------------
Sales price variance $5,400 unfav. $1,800 fav. $2,800 unfav.
======== ======== ========
Actual sales × budgeted unit sales price $69,000 $50,400 $35,000
Budgeted sales 51,750 56,000 25,000
------------- ------------- -------------
Sales volume variance $17,250 fav. $5,600 unfav. $10,000 fav.
======== ======== ========
Analysis of Cost Price and Cost Volume Variance:
Package 1 Package 2 Package 3
Actual cost of goods sold $54,000 $36,000 $21,000
Actual sales hours × budgeted hourly unit cost
#1: 1,200 hrs. × $50
60,000
31,500
28,000
------------- ------------- ---------
Cost price variance $6,000 fav. $4,500 unfav. $7,000 unfav.
Actual sales hours × Budgeted hourly unit cost $60,000 $31,500 $28,000
Budgeted cost 45,000 35,000 20,000
------------ ------------ ---------
Cost volume variance $15,000 unfav. $3,500 fav. $8,000 unfav.
======= ====== ======
Recapitulation of Sales Price Variance, Sales Volume Variance, Cost Price Variance, and Cost Volume Variance:
Sales Price Sales Volume Cost Price Cost Volume
Package 1 $ 5,400 U* $17,250 F** $ 6,000 F $15,000 U
Package 2 1,800 F 5,600 U 4,500 U 3,500 F
Package 3 2,800 U 10,000 F 7,000 F 8,000 U
---------- ---------- ---------- ------
Net variance $6,400 U $21,650 F $8,500 F $19,500 U
======= ======= ======= =======
* Favorable
** Unfavorable
Combining the net favorable sales volume variance of $21,650 with the net unfavorable cost volume variance of $19,500 leads to a net favorable volume variance of $2,150 that can be further analyzed into the sales mix variance and final sales volume
Subscribe to:
Post Comments (Atom)
Categories
- #KARACHI #MONSOON (1)
- 7 key skills of a project manager (1)
- ACCOUNTING (39)
- ACCOUNTING AND AUDIT SERVICES AVAILABLE (1)
- ACCOUNTING AND MARKETING SERVICES (1)
- Accounting for Bills of Exchange (1)
- Accounting scandals (1)
- ad (3)
- Advertisement (7)
- AMALGAMATION PRACTICE EXERCISES (1)
- B.COM (12)
- B.COM REGULAR 2011 EXAMS (1)
- BILA UNWAN 29/09/2013 بلا عنوان (1)
- BILA UNWAN 30/09/2013 بلا عنوان (1)
- Branch Accounting (1)
- Budget (1)
- Budget 2012-13 (1)
- Budget 2013-14 pakistan (1)
- BUDGET 2014-15 (1)
- BUDGET 2014-15 SALIENT FEATURES (1)
- Business SWOT Analysis - Threats is an Opportunity (1)
- Capital Budgeting (1)
- CERTIFICATE HOLDERS (1)
- COACHING CLASSES FOR B.COM (1)
- COACHING CLASSES FOR COMMERCE STUDENTS (3)
- COACHING CLASSES FOR COMMERCE STUDENTS: (2)
- COACHING CLASSES FOR FIA-ACCA STUDENTS IN KARACHI (1)
- Commerce (1)
- COST ACCOUNTING (11)
- Cricket (1)
- Decentralization (1)
- Dividend (1)
- Economics (26)
- EDUCATION (3)
- EID MUBARAK (1)
- ENRON Scandal Summary (1)
- Entertainment (2)
- Evolution of Tax Culture in Pakistan (1)
- EXEMPTIONS AWARDED BY ICAP TO VARIOUS DEGREE (1)
- fia acca (1)
- Finance (1)
- FOOD STREETS OF KARACHI: HUSSAINABAD AND AYESHA MANZIL (1)
- FREELANCE AUDIT (1)
- GOLDEN OPPORTUNITY TO MARKET YOUR BUSINESS (1)
- HISTORY (1)
- HOLDING COMPANIES (1)
- I.COM AND O/A LEVEL (1)
- icmap (1)
- Investment (1)
- Investment Decision (1)
- IQRA EDUCATION NETWORK AND CONSULTANTS: (1)
- JAVED CHOUDRY (1)
- javed chowdry on burma muslim killings (1)
- Joint Products and Joint Product Cost (1)
- KARACHI UNIVERSITY (1)
- KARACHI UNIVERSITY DATE SHEET (1)
- Khula is not regarded as a talaaq even if the word talaaq is used (1)
- MA ECONOMICS (7)
- management (3)
- Management Accounting (14)
- Marital Issues-khula (2)
- Maslow's Theory of Motivation - Hierarchy of Needs (1)
- Methods of Costing By-Products: (1)
- Movies (1)
- NEW YEAR (1)
- O/A LEVELS (1)
- PARTNERSHIP ACCOUNTS PIECEMEAL DISTRIBUTION (1)
- Politics (3)
- Post Keynesian Economics (1)
- Result (2)
- REVOLUTIONIZING RAMADAN (1)
- RISK ANALYSIS TECHNIQUES (1)
- Segment Reporting and Transfer Pricing: PART 1 (1)
- Sports (1)
- Steps to the Accounting Cycle (1)
- Stock Exchange (1)
- SYLLABUS (2)
- TIME TABLE (1)
- TIMINGS AND VENUES OF EID PRAYERS IN KARACHI (1)
- Top Story (1)
- TOPI DRAMA (1)
- TQM (1)
- Transfer pricing (1)
- Types and Classification of Bill of Exchange (1)
- UNOFFICIAL DATE SHEET B.COM KARACHI UNIVERSITY EXAMS 2011 (1)
- vat (1)
- What is a Term Finance Certificate (TFC) (1)
MY PRESENTATIONS
Khalid aziz
View more presentations from Khalid Aziz.
Analysis of financial statements
View more PowerPoint from Khalid Aziz
Cost of sales
View more presentations from Khalid Aziz
Elasticity+and+its+application
View more presentations from Khalid Aziz
Product costing
View more presentations from Khalid Aziz
Lease and ijarah
View more presentations from Khalid Aziz
Ias 36
View more presentations from Khalid Aziz.
Ias11
View more presentations from Khalid Aziz.
Accounts receivable, inventory, and total quality management
View more presentations from Khalid Aziz.
Abc costig
View more presentations from Khalid Aziz.
Budgeting
View more presentations from Khalid Aziz.
Correlation and regression
View more presentations from Khalid Aziz.
Process cost systems
View more presentations from Khalid Aziz.
Ias 20 from Khalid Aziz
Popular Posts
-
B.COM PART 1 AND 2 COACHING CLASSES FOR SUPPLEMENTARY EXAMS. HOME AND COACHING. ACCOUNTING, STATISTICS AND ECONOMICS OF PART 1. ADVANCED...
-
University Of Karachi M.A. (Previous) and M.A. (Final) Examination IN ECONOMICS SCHEME OF STUDIES M.A. (Previous) 1. The examination for deg...
-
MA-ECONOMICS PRIVATE KARACHI UNIVERSITY,REGISTRATION DATE EXTENDED.
-
B.COM 1 & 2 ACCOUNTING, STATISTICS, ECONOMICS, ADVANCED ACCOUNTING, INCOME TAX LAW JOIN SIR KHALID 0322-3385752 R-1173,AL NOOR SOCIETY, ...
-
What is a Term Finance Certificate (TFC) A corporate debt instrument issued by companies to generate short and medium-term funds. Corporate...
-
C.A. is sometimes used to identify the Chief Accountant & Chartered Accountant CAD see CASH AGAINST DOCUMENTS. CAFR see Comprehensive An...
-
In 1943, Dr. Abraham Maslow 's article "A Theory of Human Motivation" appeared in Psychological Review, which were further exp...
-
MA ECONOMICS EXTERNAL COACHING CLASSES. MICRO ECONOMICS, STATISTICS & MACRO ECONOMICS. GUESS PAPERS AND NOTES ARE AVAILABLE 0322-338575...
-
MA-ECONOMICS FOR EXTERNAL CANDIDATES CRASH CLASSES PREVIOUS & FINAL MICRO ECONOMICS MACRO ECONOMICS ADVANCED STATISTICS FOR ECONOMICS GU...
No comments:
Post a Comment