Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. module 5 excel spreadsheet instructions below you

Module 5 Excel Spreadsheet Instructions Below you will see three sets of inputs....

60.1K

Verified Solution

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.

image

Check figure (Target profit Dollar sales needed):

image

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
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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A famous problem in probability comes from the game show “Let’s Make a Deal.”  In it, a...

Statistics
Q

I am writing a marketing plan on SUNPOWER. I need information on 1. Competition 2. Product offering 3. Keys...

General Management
Q

Find a current news article focusing on one of the topics covered in the class. Critically...

General Management
Q

A A camper wants to protect her bag of food from bears She decides to...

Geometry
Q

16 45 10 OA 45 O B 045 O C 45 O D 4 5

Basic Math
Q

A hyperbola has an equation of 2x2 5y2 10 find the equation of the conjuage...

Algebra
Q

Simplify.5 log 5 (5x+2)5 log 5 (5x + 2)

Algebra
Q

A. Planning B. Implementing C. Controlling 1. Identifying five college campuses to serve as test...

Accounting
Q

part 1 part 2 part 3 part 4 ...

Accounting
Q

HA06 2.20162017: -3120162017120,000120,000: 0006,0006,0006,006,006.57.000: 51,60051,6002,4005,400: 20163,0003,00020173,0004,000. RM12,000.: 8% RM10,800 RM31,200: RM6 RM9...

Accounting
Q

A new product, an easy to store guitar stand, is being planned, with the following...

Accounting
Q

Accounting for Excise Taxes Step 1: Identification of Excisable Goods:...

Accounting