Excel_Spreadsheet_Assignment_Spring_2011

Excel_Spreadsheet_Assignment_Spring_2011 - ACC202 Excel...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
ACC202 Excel Spreadsheet Project: Budgetary Pla Objective This Excel Spreadsheet Project is aimed Part I Build the budget spreadsheet Part II Sensitivity analysis Step 1: Step 2: If your last name begins with A,B,C D,E,F G,H,I,J K,L,M,N O,P,Q R,S,T U,V,W X,Y,Z Step 3: Warning: This project is NOT a group project and s A student must present her/his own work Given a dataset, you are required to build directly in a cell of the operating budget. After you complete part I, Copy the enti Demonstrate what would happen to yo [Select ONLY ONE based on your last na Write a paragraph to comment on your f Any person involved in such an event inc
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
lainning at familiarize students with preparation of the operating budget. You need to demonstrate what would happen to your projetced net in Percentage of sales growth is now 30% Desired ending inventory of finished goods equals is now 15% Labor rate per hour is now $10.0 Sales price per unit is now $55.0 Cost of parts (Direct Material) per unit is now $8.0 Indirect Materials cost is now $1.5 Desired ending inventory of parts equals is now 5% Indirect Labor cost is now $1.0 should be done by an individual student. and should not copy the work from the other students. d the connections among the dataset and different portions of the operating You should compose the formula needed in that cell to generate a budget tire Part I worksheet to Part II worksheet our projected net income if one of the following conditions change: ame]: finding in Step 2 cluding the provider of the original work will receive a grade of zero in this
Background image of page 2
income if from the same quarter of prior year of next quarter's production of finished goods per hour per unit per unit per unit of next quarter's Cost of Parts needed for production per unit g budget. You should not type in any budget number t number. is project.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
ACC202 Excel Spreadsheet Project: Budgetary Pla Data Set Quarter Prior year sales in units Sales price per unit Percentage of sales growth Desired ending inventory of finished goods equals Cost of parts (Direct Material) per unit Desired ending inventory of parts equals Direct labor hours per unit Labor rate per hour Average hours per quuarter per employee Indirect Materials cost Indirect Labor cost Other Variable cost Percentage of current sales collected in current quarter Percentage of current sales collected in next quarter Percentage of current purchases paid in current quarter Percentage of current purchases paid in next quarter Minimum Cash Balance must be maintained You should not directly type in numbers in the cells below this line. The numbers in cells below this line must be generated from the form You need to generate the numbers in the shaded cells Prepare your Budget Hint: Use F4 key to anchor a cell in your formula after you click on th if you want to use the same cell in the formula as you move to differe Prior year sales in units Projected Units sales [prior year's sales x (1+ sales growth rate)] Sales price per unit
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/06/2011 for the course ACC 202 taught by Professor - during the Spring '11 term at SUNY Plattsburgh.

Page1 / 43

Excel_Spreadsheet_Assignment_Spring_2011 - ACC202 Excel...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online