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: 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: 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: 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…

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 Flow Relationships The following information is available for the first year of operations of Idgie Inc., a manufacturer of fabricating equipment: $1,150,100 310,500 103,500 42,600 19,600 586,600 Total manufacturing costs for the period 1,269,700 Materials inventory, end of period 42,600 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Sales Gross profit Indirect labor Indirect materials Other factory overhead Materials purchased X Open spreadsheet Using the above information, determine the following amounts: a. Cost of goods sold 839,600 501,400 264,400 X b. Direct materials cost c. Direct labor cost $
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
Quick answer of this accounting questions
PLEASE SHOW YOUR SOLUTIONS. ASAP THANKS. #28
Journal Entries in a Standard Cost System Boron Chemical Company produces a syntheticresin that is used in the automotive industry. The company uses a standard cost system. For eachgallon of output, the following direct manufacturing costs are anticipated:Direct labor: 2 hours at $25.00 per hour $50.00Direct materials: 2 gallons at $10.00 per gallon $20.00During December of the current year, Boron produced a total of 2,500 gallons of output and incurredthe following direct manufacturing costs:Direct labor: 4,900 hours worked at an average wage rate of $19.50 per hourDirect materials:Purchased: 6,000 gallons @ $10.45 per gallonUsed in production: 5,100 gallonsBoron records price variances for materials at the time of purchase.Required Prepare journal entries for the following events and transactions. (Round all amounts to nearestwhole dollar.)1. Purchase, on credit, of direct materials.2. Direct materials issued to production.3. Direct labor cost of units completed this period.4. Direct…
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…
Need answer the accounting question
Need answer