Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help in these two questions. Please solve in excel and show formulas.. If possible. Please upload excel on dropbox so i can download

I need help in these two questions. Please solve in excel and show formulas.. If possible. Please upload excel on dropbox so i can download it.

image text in transcribed

image text in transcribed

5) It is expected that the cost of direct materials will increase by 3% from 2019 to 2020. What is the direct materials budget, in dollars, for 2020? (15 Points) 6) What was the direct labor hours per unit for (rounded to the nearest .01) (0) 2018 and (ii) 2019? (15 Points) Midwest Manufacturing Statement of Income 2017 $ 5,645,357 2018 2019 $ 5,814,718 $ 6,163,601 Sales Cost of Goods Sold: Variable Costs Fixed Costs Total Cost of Goods Sold 1,467,793 395,175 1,862,968 1,395,532 523,325 1,918,857 1,787,444 369,816 2,157,260 Gross Profit 3,782,389 3,895,861 4,006,341 Administrative & Selling Expenses: Variable Administrative & Selling Costs Fixed Administrative & Selling Costs 395,175 959,711 523,325 1,104,796 523,906 1.016.994 1,354,885 1,628,121 1,540,900 Total Administrative Costs $ 2,427,504 $ 2,267,740 $ 2,465,440 Net Income Supplemental Information 2017 2018 2019 Unit Costing Summary: Units Sold Direct Labor Hours 100,810 75,607 107,680 75,376 118,531 77,045

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Theory Practice And Techniques In Bookkeeping Accounting And Auditing

Authors: N/A,

1st Edition

1680947761, 978-1680947762

More Books

Students also viewed these Accounting questions

Question

Types of Interpersonal Relationships?

Answered: 1 week ago

Question

Self-Disclosure and Interpersonal Relationships?

Answered: 1 week ago