Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. requirements a. develop an excel spreadsheet that

REQUIREMENTS A. Develop an Excel spreadsheet that includes the content outlined below in items...

50.1K

Verified Solution

Question

Accounting

REQUIREMENTS
A. Develop an Excel spreadsheet that includes the content outlined below in items 1 through 3--- use solution example provided where item was assigned and discussed in class.
B. The Excel Spreadsheet should be able to change variables for units produced and units sold:
a. Base -4000 units produced and 4000 units sold
b. Change 1-4500 units produced and 4,300 units sold
c. Change 2-4800 units produced and 4,700 units sold
The Spreadsheet should provide the following schedules and financial statements
1. Basic Schedule of Cost of Goods Manufactured
DM
DL
MO
Total Manfacturing Costs
Total and Per Unit Cost Columns for each of the above.
2. Balance Sheet - Finished Goods Inventory Account only
# of units in FG Inventory
Total and Per Unit $ Amounts for FG Inventory
3. Income Statement - Contribution Approach
Sales
Less Variable Costs
= Contribution Margin
Fixed Costs
= Net Income
Total and Per Unit $Amounts for Sales, VC and CM
Total $ amounts for FC and NI
Create one sheet for each of the above scenarios - Base, Change 1, Change 2

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!
Become a Member

Other questions asked by students

Finance
1.2K views

what are the 4 sources of capital ? explain each one

Basic Math
1.2K views

A large-scale corporate bakery needs to determine how many of their three bestselling products they can...

Medical Sciences
1.2K views

Integrative Urinary Case Study While working as a general practitioner, your patient Lamar comes to your office...

Advance Math
1.2K views

Consider an infinite sequence of positions 1, 2, 3, . . . and suppose we have...

Advance Math
1.2K views

Given that a particular solution of 2y?? +3y? +y = x^2 +7x+8 is yp1=x^2+x+1 and that...

General Management
1.2K views

Case:     Is Quality Good Marketing or Is Good Marketing Quality Please check (Chapter 4 Customer Focus) Quality is...

Biology
1.2K views

Which organism has the lowest cellular complexity and is thought to have evolved first O...

Basic Math
1.2K views

vert the accompanying database to an Excel table to find The total cost of all...

Basic Math
1.2K views

A gas station sells regular gas for $2.10 per gallon and premium gas for $2.60...

Algebra
1.2K views

termine whether sets A and B are equal equivalent both or A is the set...

Accounting
1.2K views

1. KNEX; Tegu; Mattel; Spin Master Ltd.; The LEGO Group.; PlayMonster LLC.; KnuckleStrutz; Magformers; Schylling...

Finance
1.2K views

Analysis of Receivables Method At the end of the current year, Accounts Receivable has a...