{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

This preview shows pages 1–7. Sign up to view the full content.

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 fi Any person involved in such an event inc

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

View Full Document
ainning 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 ire Part I worksheet to Part II worksheet our projected net income if one of the following conditions change: ame]: inding in Step 2 cluding the provider of the original work will receive a grade of zero in this
ncome 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. s project.

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

View Full Document
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

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

View Full Document
Budgeted sales revenue Unit sales
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}