minor and semi-minor changes in the problem): IMPORTANT: Sales commissions are paid in the same month as the sale. These equipment purchases will be financed primarily by using the firm s c

minor and semi-minor changes in the problem): IMPORTANT:

Sales commissions are paid in the same month as the sale.

These equipment purchases will be financed primarily by using the firm’s cash and by selling its marketable securities These marketable securities will be sold at cost (change from handout).

Fedders believes that OE needs to keep a minimum cash balance of $250,000 (change from handout) at the end of the quarter.

ATTACHMENT PREVIEW

Download attachment

ACC 208 – Fall 2013
Assignment – Master Budget – 30 Points
General Information:

This assignment requires you to integrate your knowledge of Financial Accounting (ACC
207), budgeting (from ACC 208) and Excel. It will take you several hours to complete.
I
am not making this up.
Do not start this assignment at the last minute.

This is a team assignment.

Each team of
no
more
than three
should submit this assignment to me via a thumb drive
and
in hard copy to me at the beginning
of class on November 12, 2013.

Only one grade per team will be awarded.

No late submissions will be accepted under any circumstances.

Any evidence of copying will be dealt with severely.
At the very least, (a) each team
member will receive a zero for this assignment and (b) an incident report of academic
misconduct will be placed in each student’s file.
Required format:
1.
Hard Copy (10 points)
a.
First page must be organized as follows:
i.
Accounting 208 Budget Problem
ii.
Fall 2013
iii.
Your class section
iv.
Members of your team, listed in alphabetical order
v.
In submitting this project, we affirm that we abided by the UD Honor
Code. (Each team member must sign this affirmation).
b.
Second (and additional)page(s):
i.
Each budget must be printed on a separate page.
ii.
Use 12 point, Times-Roman font
iii.
Title of budget should appear at the top of each page
iv.
1” margins
v.
Print Gridlines for ease of grading.
c.
All pages must be stapled.
d.
No late submissions will be accepted.
Version 1
Page
1
of
5

Unlock Solution Unlocking…

2.
Electronic submission (20 points)
a.
The purpose of this part of the assignment is to show me that you know how to
use Excel.
Thus, you are expected to use formulas (formulae)/links/functions in
completing this assignment.
Twenty points will be deducted if you simply
enter the numbers in the correct space,
even
if your solution is correct!
b.
Format:
i.
Your thumb drive must indicate on the outside body of the drive the
names of each team member.
You can do this by writing this information
on duck tape and wrapping it around the thumb drive or by marking the
drive with a marking pen or with double-sided tape.
I cannot give you a
grade if I don’t know who you are!
ii.
Excel (any version)
iii.
All of your names must appear at the top right of each page.
iv.
Each page (except the cover page) must be numbered (lower right).
v.
Each budget must appear on a different sheet. The title of each budget
should appear as the name of the sheet on which it appears.
vi.
Use 12 point, Time-Roman font
vii.
Use 1” margins
Prepare and present all reports in a neat and professional
manner.
Version 1
Page
2
of
5

Show entire document

Leave a Comment