Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I can't do this project. Is there any way I can get the answers to it with your help Project #2 - Budgeting Learning Objectives:

I can't do this project. Is there any way I can get the answers to it with your help

image text in transcribed Project #2 - Budgeting Learning Objectives: 1) Provide a comprehensive budgeting experience. 2) Exhibit the use of Excel in creating a master budget. 3) Utilize the project to perform sensitivity analysis. Learning Outcomes: 1) Understanding of the inter-relatedness of budgets. 2) Ability to utilize basic formula, cell references, and formatting. 3) Ability to perform sensitivity analysis and make decisions from that analysis. Requirements: Done (x) 1) The numbers will automatically fill-in the Data Sheet. 2) PRINT the Data Sheet. 3) TYPE the numbers from the Data Sheet that you printed into your project's Data Sheet. Save your Excel file. 4) TURN IN your printed Data Sheet in class on _MARCH 14_ (or before). 5) Utilize your textbook, lecture notes, etc. to complete the budgets. a) You may not type any numbers on the budget worksheets. b) Utilize cell references to transfer numbers from the data sheet to the worksheets. c) Use formula to perform calculations. 6) Ensure that the Income Statement shows a profit for each month. If not, change the selling price on the Data Sheet until a profit results for each month. 7) Once you have completed up through the Projected Income Statement, save your budget (as an xls or xlsx file) and submit it under the Assignments link for Project #2 Budgets. PROJECT DUE MARCH 28 @ 6PM 8) AFTER you have submitted your completed Project #2, you must use your budgeting worksheets to perform the three situational analyses listed on the "Sensitivity Analysis" worksheet (last page of the workbook). Once you have completed all three situations and entered your answers into the worksheet, save the file and upload it on Blackboard under ASSIGNMENTS - Budget Sensitivity Analysis. ALSO DUE MARCH 28 @ 6PM Excel Help: Excel 2010 Help Excel 2016 Help Project #2 (ACC 203 SPRING 2017) STUDENT NAME: INSERT NAME HERE Sales Projections in Units January February March April May Projected Sales Price/Unit 16,519 32,322 41,795 50,960 51,823 $ 21.00 Monthly Projected Selling & Administrative Expenses Variable Cost/Unit $7.00 Fixed Costs $2,936 Production: Desired Ending Inventory Beginning Inventory (new business) 79.0% 0 Materials Desired Ending Inventory 34.8% Number of Materials per Unit 12.0 Projected Cost/Material Unit $29.00 Beginning Inventory (new business) Direct Labor Time per Unit (in hours) Cost per Hour 0 2.00 $24.00 Manufacturing Overhead Variable Cost/Unit Fixed Costs $5.00 $12,806 SALES BUDGET January February Projected Sales in Units Selling Price per Unit Anticipated Sales Dollars 37 March April SELLING & ADMINISTRATIVE EXPENSE BUDGET January Sales in Units Variable S&A Rate/Unit Anticipated Variable Costs Fixed S&A Costs Total Anticipated Selling & Administrative Costs February March E BUDGET PRODUCTION BUDGET January Sales in Units Desired Ending Inventory Total Units Needed Beginning Inventory Total Production in Units February March April Sales + EI = Total Needed - BI = Production MATERIALS REQUIREMENTS BUDGET January Units to be Produced Material/Unit Total Production Need Desired Ending Inventory Total Materials Needed Beginning Inventory Total Materials Needed to be Purchased Cost per Unit of Material Total Material Cost Material/unit Cost per Unit of Material Cost of Material per Product February March ET April DIRECT LABOR BUDGET January Number of Units Produced Direct Labor Hours/Unit Total Direct Labor Hours Needed Cost/Direct Labor Hour Total Direct Labor Cost Direct Labor Hours/Unit Cost/Direct Labor Hour Cost of Direct Labor per Product February March MANUFACTURING OVERHEAD BUDGET January February March Production in Units Variable OH Rate/Unit Anticipated VOH Costs Fixed OH Costs Total Anticipated OH Costs Predetermined OH Rate Total Estimated OH Costs (for the quarter) Total Estimated DLHs (for the quarter) MOH per Unit: Predetermined MOH rate DLHs per Unit MOH per Unit of Product = per DLH PRODUCT COST PER UNIT Item Amount Direct Materials From Material Budg Direct Labor From DL Budget Manufacturing Overhead From Manu OH Budg Total Unit Cost PROJECTED INCOME STATEMENT January Sales in Units Sales Revenue Cost of Goods Sold: Gross Profit (Margin) Selling and Administrative (Operating) Expenses Operating Income February March SENSITIVITY ANALYSIS (Print and submit AFTER submitting budget online) Situation #1: What would the effect be on the Projected Operating Income if you decreased your selling price by 7% to match a price change by one of your competitors? January February March Would you recommend this action? Yes No Reasoning/Rationale (PROVIDE SIGNIFICANT EXPLANATION FOR FULL CREDIT)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems The Crossroads Of Accounting And IT

Authors: Donna Ulmer, Donna Kay, Ali Olia

1st Edition

0132132524, 9780132132527

More Books

Students also viewed these Accounting questions