Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

the first picture is the data I was given. The second is what needs to be done. all the rest is what ive done. i

the first picture is the data I was given. The second is what needs to be done. all the rest is what ive done. i just need someone to check my work and tell me if/ what i did wrong. i really dont think its right especially the last few budgets image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Project Data 1.Frame inc. manufactures bamboo picture frames that sell for $25 each. Each frame requires 4 feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $14 per hour. I-Frame has the following inventory policies: - Ending finished goods inventory should be 40% of next month's sales. - Ending direct materials inventory should be 30% of next month's production. Expected unit sales (frames) for the upcoming months followr Variable manufacturing overhead is incurred at a rate of $0.40 pes unit produced. Annual foxed manufacturing overhead is estimated to be $8,400 1 $700 per month) for expected production of 4,000 units for the vear. The budgeted manufacturing cost per unit is $17,50. In addition, selling and adminstrotive experises are estimated at $750 per month plus $0.50 per unit sold. Of its sales, Bowh is cash and 20% is on credit. Of the credit sales, 50% is collected during the same month of the sale. and 50% is collected during the month following the sale. Of direct materials purchases, 80% is paid for during the month purchased and 20% is paid in the following month Direct materials purchases for March 1 totaled $2,800. Al other operating costs are paid during the month incured. Monthly foxed manulacturing overtiead includes $260 in depreciation During April. Frame plans to pay $2,500 for a plece of equipment. Iframe had $13,500 cash on hand on April 1. Assume the company can borrow interest free in increments of $1.000 to inaintain a $13.000 ininirmuth erding cash batance. Repayments are made in the following month, assuming sufficient cash is avalable. (For example, if vou meed $4,300 at the end of 1. Sales Budget; 2. Production Budget; 3. Direct Materials Budget; 4. Direct Labor Budget; 5. Manufacturing Overhead Budget; 6. COGS Budget; 7. Selling, General \& Administrative Expenses Budget; 8. Budgeted Income Statement: 9. Cash Receipts Budget: 10. Cash Payments Budget; 11. Summary Cash Budget Final Deliverables \begin{tabular}{|c|c|c|c|c|} \hline & \multicolumn{2}{|c|}{ Company Sales Budget } & \multirow[b]{2}{*}{ June } & \multirow[b]{2}{*}{ Total } \\ \hline & April & May & & \\ \hline Unit Sales & 360 & 410 & 510 & \\ \hline x Selling p & $25 & $25 & $25 & \\ \hline Total Sales Revenue & $9,000 & $10,250 & $12,750 & $32,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline & \multicolumn{3}{|c|}{ Direct Labor Budget } \\ \hline & April & May & June \\ \hline Units to be produced & 524 & 614 & 704 \\ \hline x DL hours required per unit & 0.5 & 0.5 & 0.5 \\ \hline Total DL hours required & 262 & 307 & 352 \\ \hline Total DL cost per hour & $14 & $14r & $14 \\ \hline Total cost of DL & $3,668 & $4,298 & $4,928 \\ \hline \end{tabular} \begin{tabular}{lrrrr} & \multicolumn{3}{l}{ Cash Disbursements Budget } \\ & April & May & \multicolumn{1}{l}{ June } \\ \cline { 2 - 4 } Production expenditures & & & \\ Direct materials & $17,632 & $20,512 & $22,480 \\ Direct labor & $3,668 & $4,298 & $4,928 \\ Manufacturing Overhead & $909.60 & $945.60 & $981.60 \\ \hline SG\&A expenses & $930.00 & $955.00 & $1,005.00 \\ \hline Total cash payments & $23,140 & $26,711 & $29,395 \end{tabular} \begin{tabular}{lrrrr} & \multicolumn{3}{c}{ Combined Cash Budget } \\ & April & May & June \\ \cline { 2 - 4 } Beginning cash balance & $13,500.00 & ($640) & ($17,100) \\ + Cash Payments & $9,000 & $10,250 & $12,750 \\ \hline Cash Reciepts & $23,140 & $26,711 & $29,395 \\ \hline Preliminary cash balance & ($640) & ($17,100) & ($33,745) \end{tabular}

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

Financial Accounting

Authors: Jr. Belverd E. Needles, Marian Powers

9th Edition

0547070020, 978-0547070025

More Books

Students also viewed these Accounting questions