solve question using excel and show all work Q1 Your team pulled together the following Cost of Goods Manufactured (COGM) Schedulefor the month of July in your Dream Company's second year of operationsYou produce a line of gummies for your legal drug production company & sales have been steadyDirect Materials:Beginning Balance, Raw MaterialsPurchases of Raw MaterialsRaw Materials Available for Use(Ending Balance, Raw Materials)Raw Materials Used in Production(Indirect Materials used in prodcution)Direct Materials Used in ProductionDirect LabourManufacturing OverheadIndirect LabourProduction facility rentUtilitiesMaintenance for production equipmentCleaning and sanitization servicesDepreciation on production equipmentTotal manufactuing overhead costTotal Manufacturing CostBeginning Work in Process Inventory(Ending Work in Process Inventory)Cost of Goods Manufactured50,000165,000215,00042,000173,00030,100142,900143,40047,50040,30030,60015,30022,90015,800172,400458,70079,80078,400460,100 The following information also was shared with the management team:a)b)c)d)1)2)3)4)5)6)Required:Sales of gummies totalFinished Goods- end of June- end of July8)AdvertisingAdmin costs9)770,80075,90071,80035,000343,000For each of those suggestions, provide a risk or problem that might ariseIs the company profitable in July? (show your work)What spreadsheet function or formula would you use to ensure thatcorrections made to the COGM schedule flowed through properly to theCOGS schedule?7)if gummies sold in packs of 8, and you sold these # of packs: 64,233what is the maximum production cost per pack that would still allowthe company to remain profitable?Show the spreadsheet formula you would use to calculate thecost of goods sold per 8 packif you produced the following # of packs in Julywhat unit cost would you use to budget for August production?10) why might that budgeted unit cost not be perfectly accurate for August?Prepare the Cost of Goods Sold section for your Income StatementWhat is the Dream Company's gross margin amount?What 2 ways would you suggest to increase the gross margin?66,233

“Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…

Q1 Your team pulled together the following Cost of Goods Manufactured (COGM) Schedule for the month of July in your Dream Company's second year of operations You produce a line of gummies for your legal drug production company & sales have been steady Direct Materials: Beginning Balance, Raw Materials Purchases of Raw Materials Raw Materials Available for Use (Ending Balance, Raw Materials) Raw Materials Used in Production (Indirect Materials used in prodcution) Direct Materials Used in Production Direct Labour Manufacturing Overhead Indirect Labour Production facility rent Utilities Maintenance for production equipment Cleaning and sanitization services Depreciation on production equipment Total manufactuing overhead cost Total Manufacturing Cost Beginning Work in Process Inventory (Ending Work in Process Inventory) Cost of Goods Manufactured 50,000 165,000 215,000 42,000 173,000 30,100 142,900 143,400 47,500 40,300 30,600 15,300 22,900 15,800 172,400 458,700 79,800 78,400 460,100

Q1 Your team pulled together the following Cost of Goods Manufactured (COGM) Schedule for the month of July in your Dream Company's second year of operations You produce a line of gummies for your legal drug production company & sales have been steady Direct Materials: Beginning Balance, Raw Materials Purchases of Raw Materials Raw Materials Available for Use (Ending Balance, Raw Materials) Raw Materials Used in Production (Indirect Materials used in prodcution) Direct Materials Used in Production Direct Labour Manufacturing Overhead Indirect Labour Production facility rent Utilities Maintenance for production equipment Cleaning and sanitization services Depreciation on production equipment Total manufactuing overhead cost Total Manufacturing Cost Beginning Work in Process Inventory (Ending Work in Process Inventory) Cost of Goods Manufactured 50,000 165,000 215,000 42,000 173,000 30,100 142,900 143,400 47,500 40,300 30,600 15,300 22,900 15,800 172,400 458,700 79,800 78,400 460,100

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter4: Preparing And Using Financial Statements

Section: Chapter Questions

Problem 2EP

See similar textbooks

Related questions

Q: where is the excel sheet ,so i can see how you get the answer. I want to see the workings please

A: Excel Workings are provided in the solution in the form of Excel snip. One can use the formula…

Q: An industrial plant bought a generator set for 90,000. Other expenses including installation…

A: A) Declining Method: $1,949.20 B) Double declining Method: $2,619.93

Q: information: provide excel template to work

A: Net Present Value (NPV): NPV is a method used to assess the profitability of an investment by…

Q: how to relate cloud accounting with cost management?

A: Cloud Accounting Cloud Accounting software is similar to traditional, on premises or self installed…

Q: can you hand write it instead of using excel

A: Here,Risk Free Rate is 3%Standard Deviation of Optimal Risky Portfolio is 20%Expected Return of…

Q: Which of the following is a feature of Power Query? Change column headings so the new name appears…

A: Power Query is a data preparation and transformation tool which is part of Power BI and Microsoft…

Q: Match each of the numbered descriptions with the principle, component, or descriptor that it best…

A: Given below are the terms indicated with the meaning:

Q: The chart below is an example of a Strategy Vistalization Data. Analytics AppliedBusie Multiple…

A: Chart is a graphical representation of data which makes it more appealing and easy to understand.

Q: can you solve letters i and j manually with formulas? thank you!

Q: How is QuickBooks organized?

Q: I need help with answering this spreadsheet

A: Cost of Good manufactured is computed by adding the Material, Labor, and Overhead costs incurred…

Q: Write a research paper explaining how the T Account process works

A: T accounts are visual representations of individual accounts that looks like a "T" and is used to…

Q: Bramble Corp. is a retailer operating in Calgary, Alberta, Bramble Corp. uses the perpetual…

A: Lets understand the basics.There are various methods followed for calculating cost of goods sold and…

Q: Match the two lists, below, by placing the capital letter from List 1 in each of the cells preceding…

A: Control Environment A control environment is made up of the standards, policies, procedures, and…

Q: Please see images

A: Inventory is the goods and material a business holds for resale. LIFO:- As the name suggests Last…

Q: Select the letter of the item below that best matches the definitions that follow. a. Data Files CD…

Q: Below you will see three sets of inputs. After inputting all of your formulas, you should be able…

A: Cash budget refers to an estimation of cash inflows and outflows in a business over a specified…

Q: In the image you can look at the question . Is asking me to choose the correct answer below and fill…

A: Here, Loan Amount is $165,000 Mortgage A: Time Period (n) is 15 years Interest Rate is 6.25% Closing…

Q: how do you calculat mpg in excel?

A: Cost driver: Cost driver is one of the measurements that help the company in tracing directly the…

Q: Is there an excel table showing how to use functions?

A: The present worth of a project is a very important term for the selection and rejection decision of…

Q: Requirement Show your working

A: The calculations represented below shows the schedule of payment:

Q: me how to calculate this without using excel? Thanks

A: A mortgage payment is a regular commitment that a borrower makes to a lender in order to pay back a…

Q: Discuss a monetization model that would work for the app.

A: The final step in a thorough examination of a business model is monetization. Profitable income…

Concept explainers

Manufacturing Costs

Manufacturing cost is the total cost of procuring or producing a product. In other words, the manufacturing cost is the cost that an individual or business owner undertakes for the manufacturing of goods.

Question

solve question using excel and show all work

Q1 Your team pulled together the following Cost of Goods Manufactured (COGM) Schedule
for the month of July in your Dream Company's second year of operations
You produce a line of gummies for your legal drug production company & sales have been steady
Direct Materials:
Beginning Balance, Raw Materials
Purchases of Raw Materials
Raw Materials Available for Use
(Ending Balance, Raw Materials)
Raw Materials Used in Production
(Indirect Materials used in prodcution)
Direct Materials Used in Production
Direct Labour
Manufacturing Overhead
Indirect Labour
Production facility rent
Utilities
Maintenance for production equipment
Cleaning and sanitization services
Depreciation on production equipment
Total manufactuing overhead cost
Total Manufacturing Cost
Beginning Work in Process Inventory
(Ending Work in Process Inventory)
Cost of Goods Manufactured
50,000
165,000
215,000
42,000
173,000
30,100
142,900
143,400
47,500
40,300
30,600
15,300
22,900
15,800
172,400
458,700
79,800
78,400
460,100

The following information also was shared with the management team:
a)
b)
c)
d)
1)
2)
3)
4)
5)
6)
Required:
Sales of gummies total
Finished Goods
- end of June
- end of July
8)
Advertising
Admin costs
9)
770,800
75,900
71,800
35,000
343,000
For each of those suggestions, provide a risk or problem that might arise
Is the company profitable in July? (show your work)
What spreadsheet function or formula would you use to ensure that
corrections made to the COGM schedule flowed through properly to the
COGS schedule?
7)
if gummies sold in packs of 8, and you sold these # of packs: 64,233
what is the maximum production cost per pack that would still allow
the company to remain profitable?
Show the spreadsheet formula you would use to calculate the
cost of goods sold per 8 pack
if you produced the following # of packs in July
what unit cost would you use to budget for August production?
10) why might that budgeted unit cost not be perfectly accurate for August?
Prepare the Cost of Goods Sold section for your Income Statement
What is the Dream Company's gross margin amount?
What 2 ways would you suggest to increase the gross margin?
66,233

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Define gross margin:

VIEW

Step 2: Solving Part 1 to 3:

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Bumblebee Mobiles manufactures a line of cell phones. The management has identified the following overhead costs and related cost drivers for the coming year. The following were incurred in manufacturing two of their cell phones, Bubble and Burst, during the first quarter. REQUIREMENT Review the worksheet called ABC that follows these requirements. You have been asked to determine the cost of each product using an activity-based cost system. Note that the problem information is already entered into the Data Section of the ABC worksheet.
COST ACCOUNTING
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
PLEASE SHOW YOUR SOLUTIONS. ASAP THANKS. #28
Q2. Bolts and Brackets Limited manufactures and sells two products: arms and brackets. This year for the first time it is operating an activity-based costing system before it followed absorption costing method. The planned production activity cost pools and cost driver activity levels for all the output for the year are as follows: Activity Cost Pool ($) Purchasing materials $41,500 Storing materials $41,600 Setting up machinery $26,400 Running machinery cost $73,000 Activity Level 1,000 purchase orders 650 issue notes 200 set ups 7,300 machine hours An analysis of actual annual production usage based on activity cost pool for two products types are as follows: Arms Units produced 1,000 units Purchase orders 190 Stores issue notes 105 Set ups 35 Machine hours 2600 Direct materials $8250 Direct labor Brackets 500 units 325 200 60 1275 $3750 $46000 $7600 a) Compute the activity rates. b) Calculate the total…
dont give image in answer mode
Please do not give image format
PRACTICE EXERCISE 2: Use a separated sheet of paper for your answer. Prepare for the Projected Cost of Goods Manufactured Schedule of SARS Company for 2020 given the following: Direct Materials: Direct Labor: Manufacturing Overhead: Beginning WIP* Inventory Ending WIP Inventory *WIF is Work in Process P100,000 P50,000 P60,000 P10,000 P30,000
Flow of costs and income statement Technology Accessories Inc. is a designer, manufacturer, and distributor of accessories for consumer electronic products.Early in 20Y3,the company began production of a leather cover for tablet computers, called the iLeather.The cover is made of stitched leather with a velvet interior and fits snugly around most ttablet computers.In January, $750,000 was spent on developing marketing and advertising materials. For the first six months of 20Y3,the company spent an additional $1,400,000 promoting the iLeather.The product was ready for manufacture on January 21, 20Y3. Technology Accessories Inc. uses ajob order cost system to accumulate costs for the iLeather. Direct materials unit costs for the iLeather are as follows: Leaher $10.00 Velvet 5.00 packaging 0.40 Total $15.40 The actual production process for the iLeather is fafrly straightforward. First,leather is brought to a cutting and stitching machine. The…
Flow of Costs and Income Statement Technology Accessories Inc. is a designer, manufacturer, and distributor of accessories for consumer electronic products. Early in 20Y3, the company began production of a leather cover for tablet computers, called the iLeather. The cover is made of stitched leather with a velvet interior and fits snugly around most tablet computers. In January, $769,000 was spent on developing marketing and advertising materials. For the first six months of 20Y3, the company spent an additional $1,407,000 promoting the iLeather. The product was ready for manufacture on January 21, 20Y3. Technology Accessories Inc. uses job order costing to accumulate costs for the iLeather. Direct materials unit costs for the iLeather are as follows: Leather $10.00 Velvet 5.00 Packaging 0.40 Total $15.40 The actual production process for the iLeather is fairly straightforward. First, leather is brought to a cutting and stitching machine. The machine cuts the leather and stitches an…
Flow of Costs and Income Statement Technology Accessories Inc. is a designer, manufacturer, and distributor of accessories for consumer electronic products. Early in 20Y3, the company began production of a leather cover for tablet computers, called the iLeather. The cover is made of stitched leather with a velvet interior and fits snugly around most tablet computers. In January, $757,000 was spent on developing marketing and advertising materials. For the first six months of 20Y3, the company spent an additional $1,402,000 promoting the ileather. The product was ready for manufacture on January 21, 20Y3. Technology Accessories Inc. uses a job order cost system to accumulate costs for the ileather. Direct materials unit costs for the ileather are as follows: Leather $10.00 Velvet 5.00 Packaging 0.40 Total $15.40 The actual production process for the iLeather is fairly straightforward. First, leather is brought to a cutting and stitching machine. The machine cuts the leather and stitches…
Flow of Costs and Income Statement Technology Accessories Inc. is a designer, manufacturer, and distributor of accessories for consumer electronic products. Early in 20Y3, the company began production of a leather cover for tablet computers, called the iLeather. The cover is made of stitched leather with a velvet interior and fits snugly around most tablet computers. In January, $778,000 was spent on developing marketing and advertising materials. For the first six months of 20Y3, the company spent an additional $1,409,000 promoting the iLeather. The product was ready for manufacture on January 21, 20Y3. Technology Accessories Inc. uses a job order cost system to accumulate costs for the iLeather. Direct materials unit costs for the iLeather are as follows: Leather $10.00 Velvet 5.00 Packaging 0.40 Total $15.40 The actual production process for the iLeather is fairly straightforward. First, leather is brought to a cutting and stitching machine. The machine cuts the leather…