Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show steps or enter Excel formula 21 1 A. B c. D E F G 22 Sales Budget 23 24 25 26 27 begin{tabular}{|l|r|r|r|r|}

please show steps or enter Excel formula
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
21 1 A. B c. D E F G 22 Sales Budget 23 24 25 26 27 \begin{tabular}{|l|r|r|r|r|} \hline & \multicolumn{5}{c|}{ Sales Budget } & & & \\ \hline Unit Sales & July & August & September & \multicolumn{1}{c|}{ Total } \\ \hline Price per Unit & 2,250 & 2,100 & 1,650 & 6,000 \\ Total Sales & $220,00 & $220.00 & $220.00 & $220,00 \\ \hline \end{tabular} 28 29 30 31 32 33 34 35 \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Direct Materials Purchases Budget } \\ \hline & July & August & September & Total \\ \hline Total Production & 2,380 & 1,965 & 2,115 & 6,460 \\ \hline Direct Materials per Unit & 3.50 & 3.50 & 3.50 & 3.50 \\ \hline Materials Required for Production & 8,330 & 6,878 & 7,403 & 22,610 \\ \hline Add: Desired Ending Inventory & 1,719.38 & 1.850 .63 & 2,327.50 & 2,327.50 \\ \hline Total Material Needs & 10,049.38 & 8,728.13 & 9,730.00 & 24,937.50 \\ \hline Less: Beginning Inventory & 1,000 & 1,719.38 & 1.850 .63 & 1,000 \\ \hline Total Purchases & 9,049 & 7,009 & 7.879 & 23,938 \\ \hline Cost per Steel Ingot & $17.00 & $17.00 & $17.00 & $17.00 \\ \hline Total Cost of Direct Materials & $153,839 & $119,149 & $133,949 & $406,938 \\ \hline \end{tabular} 36 37 38 39 40 41 42 43 44 45 46 47 \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Direct Labor Budget } \\ \hline & July & August & September & Total \\ \hline Total Production & $2,380 & $1,965 & $2,115 & $6,460 \\ \hline Direct Labor Hours Per Unit & 1.50 & 1.50 & 1.50 & 1.50 \\ \hline Total Direct Labor Hours Needed for Production & 3,570 & 2,948 & 3,173 & 9,690 \\ \hline Cost per Direct Labor Hour & $19.00 & $19.00 & $19.00 & $19,00 \\ \hline Total Cost of Direct Labor & $60,690 & $50,108 & $53,933 & $164,730 \\ \hline \end{tabular} 40 Hardin Fabrications is preparing its cash budget for the third quarter

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

Top Accounting And Auditing Issues For 2021 CPE Course

Authors: CCH Tax Law Editors

1st Edition

0808055348, 978-0808055341

More Books

Students also viewed these Accounting questions

Question

How to find if any no. is divisble by 4 or not ?

Answered: 1 week ago

Question

Explain the Pascals Law ?

Answered: 1 week ago

Question

What are the objectives of performance appraisal ?

Answered: 1 week ago

Question

2. What is the business value of security and control?

Answered: 1 week ago