ACCT 484 Lecture 16: ACCT 484 Day 16
Document Summary
Get access
Related Documents
Related Questions
1 - Format the Sales Report given including: adding a header toidentify the name of the company, time period,and type of report.Also include other features you have learned to correct theformatting of the table, such as bold font or borders.
2 - Create the following Pivot tables depicting the followinginformation (Hint: Each will be shown on their own worksheet):
a)- Sum of Orders by Product and by Salesperson - this will showus which product we are selling more of and who is selling eachproduct more/less. Be sure to SORT the data in descending order toshow the highest sales by salesperson under each product.
b)- Sum of Orders by Product and by Customer - this will show uswhich product is being sold to which customer and the amount of thesales. Be sure to SORT the data in descending order to show thehighest sales by customer under each product.
c)- Salesperson by Customer -this will show us which salesperson isdealing with which customer.Be sure to SORT the data in descendingorder to show the highest sales by customer to ensure we see thecustomers in order of most sales.
3 - Using what you have learned thus far in the course, adjustthe formatting of the reports to center them on the middle of thepage and add a header to label the report,including the companyname, time period of the report, and the type of report.
4 - Label the Worksheets within the Excel Workbookaccordingly.
5 - On the appropriate worksheet, answer the following questionsonce you have completed the pivot tables:
a) - Who sells the most of Product A?
b) - Who sells the most of Product B?
c) - Who is selling the least of either product?
d) - Which product is the company selling more of?
e) - Which customers have the highest in order sales?
f) - Give an example of how this information can be used to helpSmall Builders, Inc. in maintaining their relationship with thecustomers we have identified?
Order Date | Order Amount | Customer | Salesperson | Product |
12/1/2015 | $55.00 | ABC Works, Inc. | Smith, Roland | A |
12/2/2015 | $60.00 | ABC Works, Inc. | Smith, Roland | B |
12/3/2015 | $30.00 | Manufacturing Directly, Inc. | Johnson, Larry | A |
12/4/2015 | $55.00 | Levies by Lee, LLC | Christen, Bill | A |
12/4/2015 | $65.00 | Built Tough, Inc. | Lars, Sam | B |
12/4/2015 | $60.00 | ABC Works, Inc. | Smith, Roland | B |
12/4/2015 | $45.00 | ABC Works, Inc. | Smith, Roland | B |
12/5/2016 | $50.00 | Built Tough, Inc. | Lars, Sam | B |
12/5/2016 | $60.00 | Manufacturing Directly, Inc. | Johnson, Larry | B |
12/5/2016 | $45.00 | ABC Works, Inc. | Smith, Roland | A |
12/5/2016 | $50.00 | ABC Works, Inc. | Smith, Roland | A |
12/5/2016 | $75.00 | Built Tough, Inc. | Lars, Sam | A |
12/5/2016 | $60.00 | Manufacturing Directly, Inc. | Johnson, Larry | A |
12/6/2015 | $45.00 | Lenny's Shop, LLC | Owen, Rob | A |
12/6/2015 | $50.00 | Levies by Lee, LLC | Christen, Bill | B |
12/6/2015 | $60.00 | Jobs for Less, Inc. | Owen, Rob | B |
12/6/2015 | $30.00 | ABC Works, Inc. | Smith, Roland | A |
12/6/2015 | $30.00 | Manufacturing Directly, Inc. | Johnson, Larry | B |
12/11/2015 | $65.00 | Built Tough, Inc. | Lars, Sam | B |
12/12/2015 | $60.00 | Jobs for Less, Inc. | Johnson, Larry | A |
12/13/2015 | $45.00 | Engine Repair, LLC | Erics, Rebecca | A |
12/14/2015 | $50.00 | Engine Repair, LLC | Erics, Rebecca | A |
12/14/2015 | $55.00 | Little Engineers, Inc. | Lars, Sam | A |
12/14/2015 | $60.00 | Repairs by Larry, LLC | Erics, Rebecca | A |
12/14/2015 | $50.00 | Manufacturing Directly, Inc. | Johnson, Larry | A |
12/18/2015 | $45.00 | Manufacturing Directly, Inc. | Johnson, Larry | B |
12/19/2015 | $40.00 | Built Tough, Inc. | Lars, Sam | B |
12/20/2015 | $60.00 | Built Tough, Inc. | Lars, Sam | B |
12/21/2015 | $30.00 | Bandwagon, Inc. | Owen, Rob | B |
12/21/2015 | $25.00 | Afternoon Too, Inc. | Johnson, Larry | A |
12/21/2015 | $75.00 | Afternoon Too, Inc. | Johnson, Larry | A |
12/21/2015 | $45.00 | ABC Works, Inc. | Smith, Roland | B |
12/25/2015 | $75.00 | Little Engineers, Inc. | Lars, Sam | B |
12/26/2015 | $25.00 | Jobs for Less, Inc. | Johnson, Larry | A |
12/27/2015 | $25.00 | Jobs for Less, Inc. | Johnson, Larry | B |
12/28/2015 | $30.00 | Little Engineers, Inc. | Lars, Sam | B |
12/29/2015 | $75.00 | Built Tough, Inc. | Lars, Sam | A |
12/30/2015 | $40.00 | ABC Works, Inc. | Smith, Roland | A |
12/31/2015 | $50.00 | ABC Works, Inc. | Smith, Roland | B |
Total Sales | $1,950.00 |
The Problem: The Case of the SickBuilding
This week you received a memo from one of the members of the HumanResources Department. He suspects the aging building which housesyour division is filled with mildew and other agents which causerespiratory distress. These agents are circulated throughout thebuilding and will cause more and more illnesses to occur. Herecommends that this problem be quickly remedied.
While you sympathize with him, the changes heâs suggesting willhave to come from the money the company was holding in reserve forthe next product launch. The company owns the building and thecurrent market value is $2 million. While you have insurance, youalso have a $250,000 deductible. Thus, to âcureâ the alleged âSickBuilding Syndromeâ you will have to spend $250,000 and the balanceof the expense will come from insurance. If you do not fix theproblem, it will continue to worsen.
Further, the Human Resources team has forwarded the following memoto you:
To: Human Resources
From: Marcus Keller
RE: Illness
This memo is to inform the members of the Executive Committee thatI will be taking an extended leave of absence due to my acuterespiratory problems. My doctor informs me that the symptoms andseverity of the problems are likely due to "Sick BuildingSyndrome."
Marcus Keller
Currently, three people are sick. While the health care policyyou provide for employees covers the expenses associated with theillness, your insurance premium is tied to the use of the policy.Thus, if people continue getting ill with a long term illness, thecost of insurance will increase.
Please complete each section of this worksheet. Some peoplefind that writing the answers out on another page and then "cuttingand pasting" them into the worksheet lets you think through theproblem better.
If you only have time to do part of this worksheet, click the "savework" button at the bottom of this page. At any later time, you canthen return to this worksheet and continue.
Be Attentive: Set the Context
1. Ethical Actor
The first step is to identify the ethical actor. In a sentenceidentify the ethical actor for this problem.
2. Stakeholders
The next step is to identify the stakeholders. List the otherstakeholders for this problem.
3. Assumptions
In two or three bullet points, identify any assumptions you aremaking about the problem.
Be Intelligent: Identify the Issue and the Values inTension
1. Issue
In one sentence, identify the issue for this problem.
2. Values in Tension
In three or four bullet points, identify the values intension.
Be Reasonable: Explore the Options
1. Influence Factor
In this first step, list the stakeholder groups that will beinfluenced by the decision. For each group, note the number ofstakeholders in the group. Also note the impact that any decisionwill have on each group. The impact is expressed on a scale from 1to 10.
Note that the sum of all impact numbers should add up to 10, andeach impact number must be greater than zero.
PLEASE NOTE: At least 3 stakeholders must always be defined for theethical dilemmas.
To add a stakeholder group, click the "+" button. To delete astakeholder group, click the "Ã" button next to the row containingthe group you wish to delete. Note that these actions affect alltables on this worksheet.
Stakeholder | Number in Group | Impact (1-10) | Influence Factor | |
012345678910 | ||||
012345678910 | ||||
012345678910 |
10 Remaining | ||||
2. Criteria for Happiness
In this next step, list the criteria for happiness associated withthe stakeholders and the issue at hand.
Stakeholder | Criteria |
na | |
na | |
na |
3. Units of Happiness
After brainstorming with the leadership team, you haveidentified four options:
Spend the money on the repairs to the building.
Set aside required money to handle the increased premiums due tothe illness of employees.
Do nothing and handle those who become ill through the existinghealth care and short term leave policies.
Buy a new building and sell the other building for the value ofthe land.
Choose three out of the four options to analyze. For eachoption, calculate the units of happiness (utils) for eachstakeholder group. Utils are measured on a scale of 1 to 10.
Select Option... Happiness Utils for Option 1 Happiness Utilsfor Option 2 Happiness Utils for Option 3 Happiness Utils forOption 4
Stakeholder | Utils | Rationale |
na | 0 1 2 3 4 5 6 7 8 9 10 | |
na | 0 1 2 3 4 5 6 7 8 9 10 | |
na | 0 1 2 3 4 5 6 7 8 9 10 |
4. Greatest Good
Once you have completed your analysis of this ethical dilemma bymeans of the tables above, it is possible to determine the totalweighted units of happiness. In this final step, you can see whichoption truly does produce the greatest good for the greatestnumber.
Be Responsible
1. Choose an Option
Select one option to implement within your Division:
Spend the money on the repairs to the building. |
Set aside required money to handle the increased premiums dueto the illness of employees. |
Do nothing and handle those who become ill through the existinghealth care and short term leave policies. |
Buy a new building and sell the other building for the value ofthe land. |
2. Explain Your Decision
Using the guidelines for how to write a memo, write a memo to beshared with the rest of the leadership team which explains yourdecision.
When you have completed all sections of this worksheet,please click the "continue" button below. This action will saveyour answers and advance you to the next worksheet in thisassignment. If you wish to save your current work and then returnto this worksheet at a later time, click the "save work" buttonbelow. Please note that this action will truncate any response thatexceeds the 8,000 character limit.
Now that you have reviewed information about Hi-Fi Way, you are ready to begin the first step in the accounting cycle, recording transactions. On this page of the practice set, you are asked to record transactions that occurred during the first week of June into the company's journals and post the appropriate entries to the ledger accounts. The following transactions occurred throughout the first week of June:
Week 1 | ||
Date | Transaction description | |
1 | Issued Check No. 570 for $8,400 to pay Realty Bites for two month's worth of rent in advance. | |
1 | Obtained a loan of $59,000 from ZNZ Bank at a simple interest rate of 6% per year. The first interest payment is due at the end of August 2017 and the principal of the loan is to be repaid on June 1, 2021. | |
3 | Made payment of $764 to Integer Energy for 3 months of electricity up to and including May 31, Check No. 571. | |
4 | Turbo Tech paid the full amount owing on their account. | |
4 | Paid sales staff wages of $13,224 for the week up to and including yesterday, Check No. 572. Note that $6,637 of this payment relates to the wages expense incurred during the last week of May. | |
5 | Paid the full amount owing to Big Telco, Check No. 573. | |
7 | Issued Check No. 574 to Office Supplies Warehouse for the purchase of $301 worth of office supplies. |
After completing this practice set page, you should know how to record basic transactions in the journals provided below and understand the posting process in the manual accounting system. Note that you will record the remaining June transactions in the following sections of this practice set.
Remember, one purpose of using special journals is to make the posting process more efficient by posting the total of most columns in the special journals after all of the transactions for the period have been recorded. However, some parts of a journal entry are still required to be posted on a daily basis. View the company's accounting policies and procedures for details of what is to be posted daily or monthly.
Instructions for week 1
1)Record all week 1 transactions in the relevant journals.
Note that special journals must be used where applicable. Any transaction that cannot be recorded in a special journal should be recorded in the general journal.
2)Post entries recorded in the journals to the appropriate ledger accounts according to the company's accounting policies and procedures.
Note that the relevant totals of the special journals will be posted to the general ledger accounts at the end of the month. You will enter this before you prepare the Bank Reconciliation Statement.
Remember to enter all answers to the nearest whole dollar. When calculating a discount, if a discount is not a whole number, round the discount to the nearest whole dollar. Then, to calculate the cash amount, subtract the discount from the original amount.
Additional instructions
Displaying selected accounting records:
To save space, not all accounting records (e.g. journals and ledgers) will be displayed on every page. However, on each page you can access all accounting records necessary to answer the questions on that page.
There are several tabs representing different views of the accounting records. The active tab by default is Show All, but you may also select to view just one particular accounting record by selecting the appropriate tab.
If you fill in any accounting records and change the view on the page by selecting a different tab, the information that you have entered will remain in that accounting record and be displayed whenever you can see that accounting record.
Before submitting your answers, we recommend that you click the Show All tab and check that all relevant accounting records have been completed. You are required to complete all relevant accounting records before pressing the Submit answers button. Once submitted, you will not be able to return to the page to re-enter or alter your answers.
Journals:
Each transaction recorded in a special journal must be entered in one line. In order to receive full points, you must not split up the relevant transaction into more than one line in the special journal.
For certain transactions in special journals, some accounting textbooks do not always require an account to be chosen under the column labeled Account. In this practice set you arerequired to select an account for each transaction in the special journals. Specifically, in all special journals, under the column labeled Account, you must select the correct account name for each transaction in order to receive full points. Note that for some transactions, this will mean that the account name selected will correspond to the heading of one of the columns in that special journal.
For each journal, in the Post Ref. column you will need to correctly type the account number of the account you are posting to. In particular, in special journals, some accounting textbooks do not always require a reference to be recorded in the Post Ref. column. In this practice set, in order to receive full points, every transaction entered in a special journal requires an entry in the Post Ref. column. Note that in the special journals, if the account name selected for a transaction corresponds to the heading of one of the columns in that special journal, the post ref is to be recorded as an X. This is because these transactions are not posted on a daily basis. In order to receive full points, you must record only the letter Xin the Post Ref. column for these transactions.
Note that in special journals, the Other Accounts column should not be used to record movements of inventory.
There may be entries in the general journal that require posting to both a control account and a subsidiary ledger. In these cases, after you have posted to both ledgers, you should enter the reference for both the general ledger account and the subsidiary ledger account in the Post Ref. column to indicate that you have posted to both accounts. For example, if the reference number for the control account is 110 and the reference number for the subsidiary ledger account is 110-1, you should type '110/110-1' into the Post Ref. column.
General journal entries do NOT require a description of the journal entries.
Ledgers:
When posting a transaction to a ledger account, under the Description column, please type the description of the transaction directly into the field. The exact wording does not matterfor grading purposes. For example, it does not matter in an electricity transaction if you type 'Paid for electricity' or 'Paid electricity bill'.
For each ledger, under the Ref. column, you need to select the correct journal from a list in the drop-down box provided in order to receive full points.
If the balance of a ledger account is zero you do not need to select a debit or credit from the drop-down box.
Each transaction posted to the subsidiary ledgers must be entered in one line. In order to receive full points, you must not split up the relevant transaction into more than one line in the subsidiary ledger.
Both journals and ledgers:
Most journals and ledgers will have blank rows left at the end of the page.
Some journals and ledgers may not require any entries.
When purchases and sales are recorded in special journals, changes in inventory must not be posted to the Merchandise Inventory account in the general ledger on a daily basis.