Module 5 Excel Spreadsheet Instructions

Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update.

For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided.

Check figure (Target profit Dollar sales needed):

Data Section: Fixed Variable Production costs: Direct materials Direct labor Factory overhead Selling expenses: Sales salaries \& commissions Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense Total Additional information: Selling price per unit Expected unit sales Target profit $2.30 4.70 $225,000 3.00 97,000 0.75 47,500 16,200 92,000 12,300 0.25 15,000 ======== ===== $16.00 120,000 $20,000 $1,680,000.00 9 Data Section: Production costs: Direct materials Direct labor Factory overhead Selling expenses: Sales salaries \& commissions Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense Total $2.30 4.70 $225,000 3.00 97,000 0.75 47,500 16,200 92,000 12,300 0.25 15,000 FORMULA1 ======= FORMULA2 s=z=s= Additional information: Selling price per unit $16.00 Expected unit sales 120,000 Target profit $20,000