ACC 311 Final Project II Student Workbook nvg
xlsx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
311
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
21
Uploaded by EarlSteel5127
Southern New Hampshire University
Final Project II
ACC 311 - Cost Accounting - STUDENT WORKBOOK
1.
1.
Prepare Sales Budget
Prepare Budgeted Income Prepare Schedule of Statement
Expected Cash Collection
Prepare Budgeted Balance
From Sales
Sheet
2.
2. Reporting
Prepare Merchandise Purchases Budget
In a separate Word document
Prepare Schedule of Expected
Analyze Data Cash Disbursements for
1. Briefly summarize each department's
Merchandise Purchases
budget - its purpose, what the
numbers represent, how they 3.
can be used. Also, discuss the
month to month variances, what
Prepare Selling and Admin
they mean, and why they are Budget, Including Expected
important
Cash Disbursements
2. Explain two variances that might 4.
cause concern or prompt further
analysis.
Prepare Cash Budget
In a separate Word document or PowerPoint Presentation
Executive Brief Presentation
1. Create an executive briefing presentation in which you briefly summarize all budgets. Include all supporting documentation as addendums to the brief.
MILESTONE ONE (Due in Module Five)
FINAL PROJECT (Due in Module Seven)
*Refer to Final Project II Assignment Guidelines and Rubric document
Sales Budget
Sales Budget
Admin Budget
Admin Budget
Purchasing Budget
Purchasing Budget
Financial Statements
Financial Statements
Instructions Milestone 1
Instructions Milestone 1
Instructions Final Project
Instructions Final Project
Cash Budget
Cash Budget
Southern New Hampshire University
College of Continuing Education (COCE)
ACC 311 - Cost Accounting - STUDENT WORKBOOK
IMPORTANT NOTES:
Use the data from this milestone and begin work on your final presentation, which is due in Module Se
GENERAL
SALES BUDGET
Prepare the sales budget by month and in total.
Prepare a schedule of excepted cash collections from sales by month and in total.
PURCHASING BUDGET
Prepare a merchandise purchases budget by month and in total.
Prepare a schedule of expected cash disbursements for merchandise purchases by month and ADMIN BUDGET
Prepare a selling and admin budget by month and in total.
Add expected cash disbursements for selling and admin by month and in total.
CASH BUDGET
Prepare a cash budget by month and in total.
FINANCIAL INFORMATION FOR BUDGETS - SEE PART II ASSUMPTIONS (RED TAB)
INSTRUCTIONS FOR MILESTONE 1 (Due Week 5)
Make sure to completely review
the Milestone One Final Project II Rubric.
ITEMS TO COMPLETE FOR THIS MILESTONE (Blue Tabs)
:
You are the accountant tasked with creating the master budget for SRS Educational Supply Company. You h
budget assumptions (see the red tab labeled Part II Assumptions) and are ready to prepare the following:
even.
in total.
have made your HOME
HOME
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
MOST LIKELY NUMBERS AND ASSUMPTIONS
SALES MANAGER PRIVATE INFORMATION
Most likely sales
PURCHASING MANAGER PRIVATE INFORMATION
Most likely cost of merchandise as a % of sales
Desired ending inventory as a percentage of next month's cost of sales
OPERATION MANAGER PRIVATE INFORMATION
Most likely shipping expenses as a percent of sales
Most likely other expenses as a percent of sales
Salaries and wages (per month)
Most likely advertising costs (per month)
Most likely insurance costs (per month)
Depreciation expense (per month)
FINANCE MANAGER PRIVATE INFORMATION
Percent sales collected in month of sale
Percent sales collected in month after sale
Percent of inventory purchases paid in month of purchase
Percent of inventory purchases paid in month after purchase
Percent of operating expenses paid in month of purchase
Percent of operating expenses paid in month after purchase
Desired minimum ending cash balance each month
Borrow in increments of
Monthly interest rate on borrowings (not compounded)
Other planned outlays of cash
Capital expenditures
Dividends
SRS Educational Supply Company
Balance Sheet
Previous Year End
Assets
Current assets:
Cash
Accounts receivable
Inventory
Prepaid insurance
Total current assets
Buildings and equipment (net)
TOTAL ASSETS
Liabilities and Equity
Liabilites
Accounts payable
Notes payable
Total liabilities
Stockholder's equity
Capital stock
Retained earnings
Total equity
TOTAL LIABILITIES AND EQUITY
July
August
September
October
$ 600,000 $ 910,000 $ 475,000 $ 385,000 Part 1 Information 45%
20%
Part 1 Information 5.0%
8.0%
$ 85,000 $ 50,000 $ 3,000 $ 25,000 Part 1 Information 30%
70%
50%
50%
100%
0%
$ 35,000 $ 1,000 1%
July
August
September
$ 200,000 $ 90,000 $ - $ 50,000 $ - $ - $ 40,000 $ 340,000 $ 50,000 $ 18,000 $ 448,000 $ 860,000 $ 1,308,000 Home
Home
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
$ 130,000 $ - $ 130,000 $ 420,000 $ 758,000 $ 1,178,000 $ 1,308,000
Sales Budget
July
August
September
Sales
$ 600,000 $ 910,000 $ 475,000 Schedule of Cash Collection
July
August
September
June sales (A/R From Beginning Balance Sheet)
340,000 July sales - Collected in Current Month
180,000 July sales - Collected in Following Month
420,000 August sales - Collected in Current Month
273,000 August sales - Collected in Following Month
637,000 September sales - Collected in Current Month
142,500 Total Expected Cash Collections
$ 520,000 $ 693,000 $ 779,500 Total Sales for the Quarter
A/R at the end of the Quarter (September Sales Still not Collected)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Quarter
$ 1,985,000 ns
Quarter
340,000 180,000 420,000 273,000 637,000 142,500 $ 1,992,500 $ 1,985,000 $ 332,500 View Assumptions
View Assumptions
HOME
HOME
Inventory Purchase Budget
July
August
September
October
Sales
$ 600,000 $ 910,000 $ 475,000 $ 385,000 Cost of Merchandise as % of Sales
45%
45%
45%
45%
Budgeted Cost of Merchandise Sold
$ 270,000 $ 409,500 $ 213,750 $ 173,250 Following Month's COGS
$ 409,500 $ 213,750 $ 173,250 Desired Ending Inventory %
20%
20%
20%
Desired Ending Inventory Dollars
81,900 42,750 34,650 Budgeted Cost of Merchandise Sold
270,000 409,500 213,750 893,250 Plus Desired Ending Inventory
81,900 42,750 34,650 Total Inventory Needs
351,900 452,250 248,400 Less Beginning Inventory
(50,000)
(81,900)
(42,750)
Required Purchases
$ 301,990 $ 370,350 $ 205,650 Schedule of Expected Cash Disbursements - Purchases
July
August
September
Quarter
June Purchases (A/P From Balance Sheet)
$ 130,000 $ 130,000 July Purchases
$ 150,950 $ 150,950 $ 301,900 August Purchases
$ 185,175 $ 185,175 $ 370,350 September Purchases
$ 102,825 $ 102,825 Total Disbursements
$ 280,950 $ 336,125 $ 288,000 $ 905,075 Cost of Merchandise Sold for the Quarter
$ 893,250 Ending Inventory at the end of the Quarter
$ 34,850 Ending A/P at the end of the Quarter
$ 102,825 View Assumption
View Assumption
ns
ns
HOME
HOME
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Selling and Administrative Budget
July
August
September
Quarter
Sales
$ 600,000 $ 910,000 $ 475,000 $ 1,985,000 Shipping as a Percentage of Sales
5%
5%
5%
5%
Other Expenses as a Percentage of Sales
8%
8%
8%
8%
Variable Expenses:
Shipping
30,000 45,500 23,750 99,250 Other Expenses
48,000 72,800 38,000 158,800 Total Variable Expenses
78,000 118,300 61,750 258,050 Fixed Expenses:
Salaries and Wages
85,000 85,000 85,000 255,000 Advertising
50,000 50,000 50,000 150,000 Prepaid Insurance
3,000 3,000 3,000 9,000 Depreciation
25,000 25,000 25,000 75,000 Total Fixed Expesnes
163,000 163,000 163,000 489,000 Total Selling and Admin Expenses
241,000 281,300 224,750 747,050 Less Noncash Items (Depreciation and Prepaid Ins)
(28,000)
(28,000)
(28,000)
(84,000)
Total Cash Disbursements
213,000 253,300 196,750 663,050 Prepaid Insurance That Is Expensed During the Quarter
$ 9,000 Depreciation Expense Recognized During the Quarter
$ 75,000
View Assumptions
View Assumptions
HOME
HOME
Cash Budget
July
August
September
Quarter
Cash Balance: Beginning 40,000 35,050 35,435 40,000 Add Cash Collections (From Sales Budget)
520,000 693,000 779,500 1,992,500 Total cash Available
560,000 728,050 814,935 2,032,500 Less Cash Disbursements
For Inventory (From Purchasing Budget)
280,950 336,125 288,000 905,075 For Operating Expenses (From Selling and Admin Budget)
213,000 253,300 196,750 663,050 For Equipment
200,000 90,000 0 290,000 For Cash Dividends
50,000 0 0 50,000 For Interest (From Previous Month's Borrowing)
0 $ 2,190 $ 2,080 4,270 Total Cash Disbursements
743,950 681,615 486,830 1,912,395 Excess (Deficiency) of Cash
(183,950)
46,435 328,105 120,105 Financing
Borrowing
219,000 0 0 219,000 Repayment
(11,000)
(208,000)
(219,000)
Total Financing
219,000 (11,000)
(208,000)
0 Cash Balance: Ending
35,050 35,435 120,105 120,105 Outstanding Loan Balance
Interest on Borrowing (Due the Following Quarter)
$ 4,270
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
HOME
HOME
View Assumptions
View Assumptions
Southern New Hampshire University
Final Project II
ACC 311 - Cost Accounting - STUDENT WORKBOOK
IMPORTANT NOTES:
Use the data from Milestone One and begin work on your final presentation, which is due in Module Se
GENERAL
Use data from Milestone One and the Part II Assumptions tab (the red tab) for your statement pr
BUDGETED FINANCIAL STATEMENTS
Prepare a budgeted income statement.
Prepare a budgeted balance sheet.
In a separate Word document
*Refer to Final Project II Assignment Guidelines and Rubric document
ANALYZE DATA
1. Briefly summarize each department's budget - its purpose, what the numbers represent, how they can be used.
Also, discuss the month to month variances, what
they mean, and why they are important.
2. Explain two variances that might cause concern or prompt further analysis.
In a separate Word document or PowerPoint Presentation
EXECUTIVE BRIEF PRESENTATION
1. Create an executive briefing presentation in which you briefly summarize all budgets. Include all supporting documentation (the budgets/statements) as addendums to the brief.
INSTRUCTIONS FOR FINAL PROJECT II (Due Module Seven
Make sure to completely review
the Final Project II Rubric.
ITEMS TO COMPLETE FOR FINAL PROJECT II (Purple Tabs)
:
even.
reparation.
n)
HOME
HOME
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
SRS Educational Supplies Company
Budgeted Income Statement
For the Quarter Ended September 30th
Sales
Cost of Goods Sold
1,985,000 Gross Margin
89,250 Selling and Administrative Expenses
1,091,750 Shipping
99,250 Other
158,800 Salaries and Wages
255,000 Advertising
15,000 Prepaid Insurance
9,000 Depreciation
75,000 747,050 Net Operating Incomes
344,700 Less Interest Expense
4,270 Net Income
340,430 SRS Educational Supply Company
Balance Sheet
September 30th
Assets
Current Assets:
Cash
$ 120,015 Accounts receivable
332,250
Inventory
34,650 View Assumptions
View Assumptions
Home
Home
Prepaid Insurance
9,000 Total Current Assets
495,915 Buildings and Equipment (Net)
1,075,000 Total Assets
$1,570,915 Liabilities and Equity
Accounts Payable
102,825 Notes Payable
0 102,825 Stockholder's Equity
Capital Stock
420,000 Retained Earnings
1,048,430 Total Liability and Equity
1,571,255
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
please help me with c and use the formatting provided. thanks! please help quickly!
arrow_forward
Match the definitions 1 through 8 with the term or phrase a through h. a. Budget e. Master budget b. Top-down budgeting f. Budgetary slack c. Participatory budgeting g. Sales budget d. Cash budget h. Budgeted income statement 1. Shows expected cash inflows and outflows and helps determine financing needs. 2. A plan showing units to be sold; the usual starting point in the master budget process. 3. A report that shows predicted revenues and expenses for a budgeting period. 4. A formal statement of future plans, usually expressed in monetary terms. 5. Approach in which top management passes down a budget without employee input. 6. A budgetary cushion used to meet performance targets. 7. A comprehensive business plan that includes operating, investing, and financing budgets. 8. Employees affected by a budget help in preparing it.
arrow_forward
Understanding the components of the master budget
The following are some of the components included in the master budget of a merchandising company.
Budgeted balance sheet
Sales budget
Capital expenditures budget
Budgeted income statement
Cash budget
Inventory, purchases, and cost of goods sold budget
Budgeted statement of cash flows
Selling and administrative expense budget
List the items of the master budget in order of preparation.
arrow_forward
A company has completed the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Please use the below image as your guide for the next 5 questions.
Identify the document that contains finished goods inventory.
A
B
C
D
E
arrow_forward
Question 6. Please answer in same format as question so it's easy to transfer over
arrow_forward
A company has completed the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Please use the below image as your guide for the next 5 questions.
Identify the document that contains equipment purchases
A
B
C
D
E
arrow_forward
Describe the 5 types of budgets
listed for these Wk 3 Financial
Exercises: Problem Set 2, Part 1.
In your descriptions, include the
budget's objective, how the
budget assists an organization in
managing its financial activities,
and what types of data need to be
included in that specific budget.
Type of Budget
Cash Flow
Operating
Sales
Static
Financial
Description
Insert cash flow description.
Insert operating description.
Insert sales description.
Insert static description.
Insert financial description.
arrow_forward
A company has completed the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Please use the below image as your guide for the next 5 questions.
Identify the document that contains accounts payable
A
B
C
D
E
arrow_forward
Which of the following is the cornerstone (or most critical element) of the master budget?
a. The operating expenses budgetb. The budgeted balance sheetc. The sales budget
d. The inventory, purchases, and cost of goods sold budget
The budgeted statement of cash flows is part of which element of Amazon.com’s master budget?
The financial budget
The operating budget
The capital expenditures budget
None of the above
arrow_forward
Question 1
arrow_forward
Chapter 22. Question 1. Please fill in the blanks with the possible answers attached
arrow_forward
How do I solve the chart?
arrow_forward
Order the following terms and operations to
create the formula for the combined cash
budget (before any financing is considered).
E Beginning Cash Balance
| Cash Payments
4
: Cash Collections
Ending Cash Balance (before
Financing)
::::
::::
arrow_forward
Assets
Cash
Minden Company
Balance Sheet
April 30
Accounts receivable
Inventory
Buildings and equipment, net of depreciation
Total assets
Liabilities and Stockholders' Equity
Accounts payable
Note payable
Common stock
Retained earnings
Total liabilities and stockholders' equity
$ 11, 100
72,500
37,500
238,000
$ 359,100
$ 68,000
19,400
180,000
91,700
$ 359,100
The company is in the process of preparing a budget for May and assembled the following data:
a. Sales are budgeted at $255,000 for May. Of these sales, $76,500 will be for cash; the remainder will be credit sales. One-half of a
month's credit sales are collected in the month the sales are made, and the remainder are collected in the following month. All of
the April 30 accounts receivable will be collected in May.
b. Purchases of inventory are expected to total $189,000 during May. These purchases will all be on account. Forty percent of all
purchases are paid for in the month of purchase; the remainder are paid in the following…
arrow_forward
The last budget to be prepared in the master budget
Balance sheet
Cash budget
Income statement
Selling and administrative expenses budget
Group of answer choices
1
2
3
4
arrow_forward
Provide a letter of advice:• discuss the key results of the income statement and cash budget• make one suggestion on how the client could improve the financial success of the cost management strategy• identify and discuss one non-financial factor that might affect the client’s decision to proceed with the chosen proposal• clearly state whether the client should proceed with the chosen proposal and why
arrow_forward
In Quickbooks
1) To create a budget:A) From the Company Center, select Company & Financials > BudgetsB) From the Edit Menu, select Preferences > Set Up BudgetsC) From the Company Menu, select Planning & Budgeting > Set Up BudgetsD) From the Banking Menu, select Planning & Budgets > Budgets
Group of answer choices
A
B
C
D
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Related Questions
- please help me with c and use the formatting provided. thanks! please help quickly!arrow_forwardMatch the definitions 1 through 8 with the term or phrase a through h. a. Budget e. Master budget b. Top-down budgeting f. Budgetary slack c. Participatory budgeting g. Sales budget d. Cash budget h. Budgeted income statement 1. Shows expected cash inflows and outflows and helps determine financing needs. 2. A plan showing units to be sold; the usual starting point in the master budget process. 3. A report that shows predicted revenues and expenses for a budgeting period. 4. A formal statement of future plans, usually expressed in monetary terms. 5. Approach in which top management passes down a budget without employee input. 6. A budgetary cushion used to meet performance targets. 7. A comprehensive business plan that includes operating, investing, and financing budgets. 8. Employees affected by a budget help in preparing it.arrow_forwardUnderstanding the components of the master budget The following are some of the components included in the master budget of a merchandising company. Budgeted balance sheet Sales budget Capital expenditures budget Budgeted income statement Cash budget Inventory, purchases, and cost of goods sold budget Budgeted statement of cash flows Selling and administrative expense budget List the items of the master budget in order of preparation.arrow_forward
- A company has completed the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Please use the below image as your guide for the next 5 questions. Identify the document that contains finished goods inventory. A B C D Earrow_forwardQuestion 6. Please answer in same format as question so it's easy to transfer overarrow_forwardA company has completed the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Please use the below image as your guide for the next 5 questions. Identify the document that contains equipment purchases A B C D Earrow_forward
- Describe the 5 types of budgets listed for these Wk 3 Financial Exercises: Problem Set 2, Part 1. In your descriptions, include the budget's objective, how the budget assists an organization in managing its financial activities, and what types of data need to be included in that specific budget. Type of Budget Cash Flow Operating Sales Static Financial Description Insert cash flow description. Insert operating description. Insert sales description. Insert static description. Insert financial description.arrow_forwardA company has completed the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Please use the below image as your guide for the next 5 questions. Identify the document that contains accounts payable A B C D Earrow_forwardWhich of the following is the cornerstone (or most critical element) of the master budget? a. The operating expenses budgetb. The budgeted balance sheetc. The sales budget d. The inventory, purchases, and cost of goods sold budget The budgeted statement of cash flows is part of which element of Amazon.com’s master budget? The financial budget The operating budget The capital expenditures budget None of the abovearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College