Given the information below, complete the following requirements:
A. Rank the customers by their gross margin as a percent of sales revenue.
B. Perform customer profitability analysis by generating an operating income for each customer segment through the use of activity-based costing.
C. Rank segments by their respective operating income as a percent of sales.
D. If the relative rankings of the segments using operating income as a percent of sales is different from the relative rankings using gross margin as a percent of sales, then provide two reasons why this change might have occurred.
Space is provided on the following two pages for your answer. Be sure to show your work for partial credit should you make an error.
Pharmacy
Hospital
HMO
Clinics
Revenue
$1,000,000
$1,200,000
$800,000
$600,000
CGS
$670,000
$720,000
$560,000
$390,000
Activity
Rate
Cost Driver
Order taking
$200.00
per purchase order
Information requests
$350.00
per request
Sales calls
$400.00
per sales call
Distribution
$150.00
per delivery
Expedited orders
$500.00
per expedited order
Activity Cost Driver Quantities
Activity Cost Driver
Pharmacy
Hospital
HMO
Clinics
Number of purchase orders
100
200
20
80
Number of requests
50
100
20
20
Number of sales calls
50
200
10
40
Number of deliveries
80
100
10
40
Number of expedited orders
40
150
8
60
In: Accounting
Case
Azzahra is a book publisher, publishes and distributes educational and non-educational books and sell them to libraries and bookstores within Saudi Arabia and in the Arabian Gulf Region (AGR).
Azzahra employs a professional editorial team. All printing and binding activities are outsourced. The annual revenue total 250 millions Saudi Riyals which are disbursed as follows:
|
In millions |
Cash |
Credit |
Total |
Total Customers |
|
Within Saudi |
40 | 120 | 160 | 4680 |
|
From other AGR |
10 | 80 | 90 | 2120 |
|
Total |
50 | 200 | 250 | 7800 |
Cash expenditures are 150 million Saudi Riyals. Non-cash expenditures are 50 million Saudi Riyals. While revenues may be paid in different currencies, all processed out in the main center in Riyadh and using Saudi Riyal.
Requirement
Suppose you are a member of the professional editorial team and your task is to audit the revenue and accounts receivable. You probably would like to perform your audit in the following order:
1- Establish audit objectives
2- Determine the scope of the audit
3- Apply the Seven Habits of Highly Effective People (expected outcomes).
4- Understand the auditee (gather relevant information, analytical procedures, control
analysis, process flow, process risks)
5- Identify and assess risks
6- Identify key controls
7- Evaluate controls
8- Create test plan
9- Develop work program
10- Gather evidences
11- Evaluate evidences and reach conclusion
12- Develop observation and formulate recommendation.
In: Accounting
Gulf Delivery Service, Inc. completed the following transactions during January, 2018:
1Shareholders invested in the business $25,000 cash and a delivery truck valued at $35,000 in exchange for common stock.
2.Purchased supplies for $1,000 cash.
3.Paid $2,400 for a one-year insurance policy, effective January1.
3.Performed delivery services for a customer and received $2,500 cash.
4.Completed a large delivery job for a customer on account for $8,000.
5.Paid $6,000 for employee salaries.
6.Performed delivery services for customers and received $55,000 cash.
7.Collected $4,000 in advance for delivery service to be performed later.
8.Collected $3,000 cash from a customer on account.
9.Purchased fuel for the truck , paying $1,500 with a company credit card (Credit accounts payable).
10.Performed delivery services on account, $4,500.
11.Paid office rent $2,500.
12.Paid $500 for accounts payable.
13.Paid cash dividends of $10,000.
a.
Record each transaction in the journal. Key each transaction by its letter (Explanations are not required).
b.Post the transactions that you recorded in requirement 1 to the ledger accounts using T-accounts. The ledger for Gulf Delivery Service contains the following accounts:
Cash Service revenue
Accounts receivable Salaries expense
Supplies Depreciation expense
Prepaid insurance Insurance expense
Delivery truck Fuel expense
Accumulated depreciation rent expense
Accounts payable supplies expense
Salaries payable
Unearned service revenue
Common stock
Retained earnings
Dividends
Income summary
In: Accounting
Laundromat is trying to enhance the services it provides to? customers, mostly college students. It is looking into the purchase of new? high-efficiency washing machines that will allow for the? laundry's status to be checked via smartphone.
FulmarFulmar
estimates the cost of the new equipment at
$178,000.
The equipment has a useful life of 9 years.
FulmarFulmar
expects cash fixed costs of
$80,000
per year to operate the new? machines, as well as cash variable costs in the amount of
15%
of revenues.
FulmarFulmar
evaluates investments using a cost of capital of
6?%.
Requirement 1. Calculate the payback period and the discounted payback period for this? investment, assuming
FulmarFulmar
expects to generate
$ 190 comma 000$190,000
in incremental revenues every year from the new machines.? (Round your answer to two decimal? places.)
|
The payback period for the investment assuming uniform net cash inflows is |
years. |
Requirements:
|
1. |
Calculate the payback period and the discounted payback period for
this? investment, assuming
FulmarFulmar expects to generate$ 190 comma 000$190,000 in incremental revenues every year from the new machines. |
|
2. |
Assume
instead that
FulmarFulmar expects an uneven stream of incremental cash revenues from installing the new washing machines. Based on this estimated revenue? stream, what are the payback and discounted payback periods for the? investment? |
|
Year |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
|
Projected Revenue |
$85,000 |
$130,000 |
$140,000 |
$170,000 |
$180,000 |
$170,000 |
$140,000 |
$150,000 |
$185,000 |
In: Accounting
| debit | credit | |
| cash | 6900 | |
| accounts receivable | 4500 | |
| prepaid rent | 6300 | |
| supplies | 2250 | |
| equipment | 18000 | |
| accumulated depreciation | 900 | |
| unearned revenue | 1500 | |
| notes payable | 10 000 | |
| contributed capital | 8000 | |
| retained earnings, 1 april | 12200 | |
| service revenue | 11200 | |
| advertising expense | 650 | |
| depreciation expense | 900 | |
| interest expense | 150 | |
| rent expense | 2100 | |
|
salaries expense dividends totals |
1700 350 43800 |
43800 |
Additional Information:
i Rent expires (is used up) at a rate of $700 per month.
ii Monthly depreciation on equipment is $300.
iii Interest on the 6 per cent promissory note is
paid quarterly on
1 April, 1 July, 1 October and 1 January.
iv Performed services for which payment was received in April– $800.
v Received electricity bill to be paid next month – $500.
vi Services to customers earned during June but unrecorded at 30 June, $2500
. vii Supplies on hand totaled $1500 at 30 June.
viii Owed employees for salaries for the last week of June to
be
paid in July – $800
. ix Prime Realty prepares adjusting entries each quarter adjustments were last made on 31 march
Required
a Prepare all adjusting journal entries for the quarter
ending 30 June.
b Post journal entries to T-accounts using totals on
the unadjusted trial balance as the opening balances
c Prepare an adjusted trial balance as of 30 June
In: Accounting
The POL Company had started its operations in 2016. The balance sheet for December 31, 2016, showed the following accounts balances (there were no other accounts listed):
Accounts receivables 45
Unearned revenue 40
Accumulated depreciation 10
Common stock 500
Retained earnings 57
Property plant and equipment (gross) 200
Inventory 75
Accounts payable 40
Cash 309
Prepaid rent ______
During 2017 the following transactions occurred:
1. POL purchased $375 worth of inventory on account.
2.Payments on Accounts payable were $365.
3.Cash sales were $260; credit sales were $360.
4.Ending inventory was $59.
5.Depreciation expense was $20.
6.Collections from customers (not including cash sales) were $312.
7. The Prepaid rent had expired during the year.
8. POL hired one employee, who worked for the entire year at $4 per month. At the end of the year, POL owes its employee $6.
9.Dividend of $24 was declared and paid during 2017.
10. On the last day of the year, POL gave a loan of $50 to its twin sister company, CLA.
11.Unearned revenue account remained intact during 2017.
a.What was the balance of the Prepaid rent account on December 31, 2016?
b.Record journal entries for all transactions occurred during 2017.
c.Prepare an Income Statement for the year ended December 31, 2017.
d. Prepare a Balance Sheet for December 31, 2017.
In: Accounting
Custom Auto Parts started this year with the following balances:
Cash: $60,000
Merchandise Inventory: $8,000
Land: $12,000
Accounts Payable: $0
Common Stock: $50,000
Retained Earnings: $30,000
During the year they had the following transactions:
Purchase $60,000 of merchandise inventory on account, terms 2/10,n/30.
The goods delivered in Event 1 were delivered FOB shipping point. Freight costs of $1,500 were paid in cash by the responsible party
Returned $3,000 of goods purchased in Event 1
Paid the balance due on the goods purchased in Event 1 and recorded the cash discount.
Recognized $59,000 of cash revenue from the sale of merchandise and recognized $45,000 of cost of goods sold from such sale.
The goods sold in Event 5 were delivered to the customers FOB destination. Freight costs of $1,400 were paid in cash by the responsible party.
Paid $9,000 in cash for selling and administrative expenses.
Sold the land for $14,500 in cash.
Using Excel, assuming a perpetual inventory system, record each transaction in the horizontal statements model.
After completing the recording of the transactions, prepare a multistep income statement. Include common size percentages on the income statement.
I need help with this part below!!
| Event | Revenue | Capital Gain on Sale of Land | Cost of Goods Sold | Selling and Adminstrative | Transportation-Out | Net Income | ||
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 59000 | 0 | -45000 | 0 |
0 |
In: Accounting
| Fresno Fiber Optics, Inc. manufactures fiber optic cables for the computer | |||||||||
| and telecommunication industries. At the request of the company VP of | |||||||||
| marketing, the cost management staff has recently completed a customer- | |||||||||
| profitability study. The following activity-based costing information was | |||||||||
| the basis for the analysis. | |||||||||
| Customer - Related Activities | Cost Driver Base | Cost Driver Rate | |||||||
| Sales activity | Sales visits | $860 | |||||||
| Billing and Collection | Invoices | 160 | |||||||
| Order taking | Purchase orders | 220 | |||||||
| Special shipping | Shipments | 430 | |||||||
| Customer - Related Activities | Trace Telecom | Caltex Computer | |||||||
| Sales activity | 14 visits | 18 visits | |||||||
| Billing and Collection | 22 invoices | 26 invoices | |||||||
| Order taking | 26 orders | 28 orders | |||||||
| Special shipping | 12 shipments | 14 shipments | |||||||
| The following additional information has been compiled for Fresno Fiber Optics | |||||||||
| for two of its customers, Trace Telecom and Caltex Computer, for the most recent year. | |||||||||
| Trace Telecom | Caltex Computer | ||||||||
| Sales revenue | $240,000 | $226,000 | |||||||
| Cost of goods sold | 140,000 | 110,000 | |||||||
| General selling costs | 42,000 | 32,000 | |||||||
| General administrative costs | 24,000 | 18,000 | |||||||
| Required: | |||||||||
| 1. Prepare a customer profitability analysis for Trace Telecom and Caltex Computer. | |||||||||
| (Hint: Refer to Exhibit 5-13 for guidance). | |||||||||
| 2. Build a spreadsheet: Construct an Excel spreadsheet to solve requirement (1) above. | |||||||||
| Show how the solution will change if the following information changes: Trace Telecom's | |||||||||
| cost of goods sold was $114,000 and Caltex Computer's sales revenue was $206,000. | |||||||||
In: Accounting
Hervis Car Rental in Austin, Texas, has 50 high-performance
Shelby-H Mustangs in its rental fleet. These cars will be in
greater demand than usual during the last weekend in July when the
Central Texas Mustang Club holds its annual rally in Austin. At
times like this, Hervis uses a revenue management system to
determine the optimal number of reservations to have available for
the Shelby-H cars.
Hervis has agreed to have at least 60% of its Shelby-H Mustangs
available for rally attendees at a special rate. Although many of
the rally attendees will request a Saturday and Sunday two-day
package, some attendees may select a Saturday-only or a Sunday-only
reservation. Customers not attending the rally may also request a
Saturday and Sunday two-day package, or make a Saturday-only or
Sunday-only reservation. Thus, six types of reservations are
possible. The cost for each type of reservation is shown
here.
|
Two-Day |
Saturday- |
Sunday- |
|
|
Package |
Only |
Only |
|
|
Rally |
$125 |
$75 |
$65 |
|
Regular |
150 |
85 |
75 |
The anticipated demand for each type of reservation is as
follows:
|
Two-Day |
Saturday- |
Sunday- |
|
|
Package |
Only |
Only |
|
|
Rally |
20 |
10 |
15 |
|
Regular |
10 |
20 |
25 |
Hervis Car Rental would like to determine how many Shelby-H
Mustangs to make available for each type of reservation in order to
maximize total revenue.
In: Operations Management
ORIGINAL Question (This has been asked and answered on previous forums)
John's Boat Yard, Inc., repairs, stores, and cleans boats for customers. It is completing the accounting process for the year just ended on November 30. The transactions for the past year have been journalized and posted. The following data with respect to adjusting entries at year-end are available:
John's winterized (cleaned and covered) three boats for customers at the end of November, but did not record the service for $4,200.
On October 1, John's paid $1,680 to the local newspaper for an advertisement to run every Thursday for 12 weeks. All ads have been run except for three Thursdays in December to complete the 12-week contract.
John’s borrowed $258,000 at a 9 percent annual interest rate on April 1 of the current year to expand its boat storage facility. The loan requires John's to pay the interest quarterly until the note is repaid in three years. John's paid quarterly interest on July 1 and October 1.
The Johnson family paid John’s $4,080 on November 1 to store its sailboat for the winter until May 1 of the next fiscal year. John's credited the full amount to Unearned Storage Revenue on November 1.
John’s used boat-lifting equipment that cost $260,000; $26,000 was the estimated depreciation for current year.
Boat repair supplies on hand at the beginning of the current year totaled $18,100. Repair supplies purchased and debited to Supplies during the year amounted to $47,600. The year-end count showed $13,100 of the supplies on hand.
Wages of $5,300 earned by employees during November were unpaid and unrecorded at November 30. The next payroll date will be December 5 of the next fiscal year.
Current Questions: (Questions I am seeking help with - I am seeking explanations)
I am confused by this problem. The fiscal year for this company goes from November 30th to November 30th, from year to year? Is that correct?
We are then making adjusting entries to cover the remainder of the calendar year, which in this instance covers the month of December?
How is the answer to "C" regarding the payment of interest derived? I see that the company pays 9% interest on a $258,000 dollar loan, which equates to $21,600 dollars interest per year. It seems that the answer seeks the student to solely log two months interest or $3,600 dollars. But if the matter was paid on July 1st and Oct 1st, by the time of Nov. 30th would these transaction not have already been recorded??? What is going on here?
Also, specifcally with respect to part "F" concerning the cost of supplies - Would we not determine the unadjusted balance by combining the beginning balance ($18,100) + purchases ($47,600) to arrive at an unadjusted balance from which we would need to adjust down to the current level of supplies on hand ($13,100)? I do not understand how/why we would simply adjust from the beginning balance to the ending balance and assume that entries for the $47,600 dollars worth of supply purchases were not journaled and recorded. Are you able to explain this, as similar posts simply subtract beginning balance from ending balance and add entries to the ledger for the difference. (This differs from the text's example and I cannot tell what I should be reading within the context of the problem to know when to do what method.)
In: Accounting