Unformatted Attachment Preview
IS 2200 - PowerPoint Assignment (50 points)
Submit a PowerPoint presentation file (.pptx) that uses a minimum of ten (10) slides to
illustrate the Fins Seafood Diner business case based on the Excel assignment. Please
name it with YourLastnamePPT.pptx
Your presentation should be complete. Please ensure that you include the following
components:
a. A complete structure for your presentation:
1. Introduction to the presentation (cover slide, outline slide).
2. Discussion of the case (important numbers, observations, etc.)
3. Sales by product (1 slide including graphic from Excel).
4. Your opinion of the figures (recommendations/suggestions)
5. Summary of the presentation.
b. Using Notes Page, write speaker notes under each slide as if someone else beside you
is doing the presentation. Make these notes extensive.
c. Use footers and headers to identify your presentation. Date your presentation and
number your slides.
d. Use at least one clip art image.
e. Record narration for all of your slides.
f. Refer to the following rubric for requirements:
Criteria – 10 slide minimum
Content
Spelling and grammar (10 slide minimum)
Notes used effectively
Slide transition preset?
Linked Chart from pro forma?
Graphics to enhance?
Sound use appropriate?
Slide numbers/date
Max. Points.
10 points
05 points
10 points
05 points
05 points
05 points
05 points
05 points
1
Your score:
0
0
0
0
0
0
0
0
Net realizable value = AR Balance less Allowance for Doubtful Accounts
$
22,000 AR Balance
$
(1,480) Allow for Doubtful Accts
$
20,520 Realizable Value before write off
The $480 Write off reduces both the AR Balance and the Allowance for Doubtful Acct Balance so Net AR doesn’t change
21520 Adjusted AR Balance
-1000 Adjusted Allow for doubtfull accts
$
20,520 Realizable value after write off
The write off has no effect on the realizable value since it was already included in the allowance for doubtful accounts
Answer = $20,520
Since they did not have a beginning balance in Allowance for Doubtful Accounts
For this one you would just multiply the sales on account $53,000 x 8% = $4,240
Answer = $4,240
$
$
$
$
$
210,000
(7,140)
2,800
4,400
210,060
List Price
Discount @ 3.4%
Shipping - FOB means the buyer pays Shipping
Installation Costs
The insurance cost is an expense, not part of the cost of the asset
Answer = $210,060
Aging
Current
0-30
31-60
61-90
over 90
$
$
$
$
$
$
% uncollectible
AR Bal
26,700
12,650
2,550
1,180
1,300
44,380
8%
12%
17%
32%
57%
Allow for
Uncollectible
$ 2,136.00
$ 1,518.00
$
433.50
$
377.60
$
741.00
$ 5,206.10 (a)
$
$
$
2970
-3020
(50.00)
5,206.10
5,256.10
beginning balance in Allow for doubtful accts
Write Offs during the year
Balance before year end adjustment
Year end Balance Should be (a)
Adjustment to correct balance
You need to adjust the balance in allowance for doubtful accounts to the correct balance at year end.
In this problem the balance in allowance for doubtful accounts was a debit of $50 before the
year end adjustment, so in order to bring it to a credit balance of $5,206.10 the adjustment is
$5,206.10 + $50 = $5,256.10
Answer = $5,256.10
Gross amount of Receivable
Less 6% service charge
$
$
$
5,500
(330)
5,170 Net amount company will collect from credit card company
The entry to record this would be a debit to Accounts Receivable for $5,170 and a credit to revenue for $5,170
Since Accounts Receivable is an asset account, assets will increase by $5,170
Answer = Assets will increase by $5,170
Units of Prod. Depreciation =
Number of Units Produced
× (Cost − Salvage Value)
Life in Number of Units
List Price
less 3% discount
Installation
Less Salvage Value
Depreciable value
Total Units useful life
Depreciation per Unit
X 80,000 units
$
$
$
$
$
$
$
17,700
(531)
2,000
(3,900)
15,269
800,000
0.019
1,527
cost
cost
cost
salvage value
total units useful life/depreciable value
Answer = $1,527
Note: Insurance and Maintenance have no impact on the depreciation
$
$
$
$
$
11,500
17.0%
1,955
162.92
1,466.25
488.75
Loan Amount
Annual Interest Rate
Annual Interest
Interest per month
2011 = 9 months ($162.92*9)
2012 = 3 month ($162.92*3)
Answer = $1,466.25, $488.75
List Price
Less 3% Discount
Transportation
Sales Tax
Installation
Cost of Machine
$
$
$
$
$
$
Routine Maintenance is not included
Answer = $51,920
48,000
(1,440)
1,100
3,360
900
51,920