Module 5 Excel Spreadsheet Instructions Below you will see three sets of inputs. After...
80.2K
Verified Solution
Link Copied!
Question
Accounting
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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!