Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is needed: I also would need the excel formula cell reference. Adding the missing information: Hopefully this helps ? Given: Budgeted Unit Price =

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

this is needed:

image text in transcribed

image text in transcribed

I also would need the excel formula cell reference. Adding the missing information:

image text in transcribedimage text in transcribedimage text in transcribed

Hopefully this helps ?

Given: Budgeted Unit Price = Ending Finished Goods = Beg. Finished Goods = Material per unit Price for unit of material Ending Materials Beginning Materials $40 per pair 5% Next Q Sales 1,300 units 2 yards per unit $1.50 per yard 3% of next Q production needs 3% of current production needs labor per unit Labor Rate V MOH Applied Rate F MOH 0.25 labor hours $14.00 per labor hour 40% of DL costs ($) $264,600 annual Financial Budgets 1. Create the Cash Receipts Budget 01 02 03 04 Annual 40% 40% 40% Budgeted Sales Revenue Cash Sales (56) Cash Sales (S1 Credit Sales (5) % Collected in Sameo $ Collected in Same Q % Collected in Next Q $ Collected in Next Q Budgeted Cash Receipts 75% 25% 25% 25% $125,000 2. Create the Cash Payments Budget 01 02 03 04 2019 Annual Budgeted DM Purchases (S) 20% 20% 20% 20% 20% 80% 80% 30% 30% 80% $70,000 Cash paid in Q of Purchase % Paid $ Paid Cash paid in Next Q % Paid $ Paid 1 Cash paid for Direct Materials 2 Cash paid for Direct Labor Manufacturing Overhead MOH Expenses Less Depreciation (non-cash) 3 Cash paid for MOH 4 Cash paid for SGA Expenses 5 Equipment Purchases Budgeted Cash Payments $50,000 $50,000 $50,000 $50,000 $200,000 3. Create a Cash Budget 02 03 04 Annual $108,000 Beginning Cash Balance +Cash Receipts - Cash Payments Cash before Financing Cash Borrowed (or Repaid) Min Balance: $100,000 Ending Cash Balance increments of $1,000 4. Create Budgeted Balance Sheet

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

Step: 3

blur-text-image

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

Research Methods In Accounting

Authors: Malcolm Smith

6th Edition

1529779774, 978-1529779776

More Books

Students also viewed these Accounting questions

Question

Explain the importance of Human Resource Management

Answered: 1 week ago

Question

Discuss the scope of Human Resource Management

Answered: 1 week ago

Question

Discuss the different types of leadership

Answered: 1 week ago

Question

Write a note on Organisation manuals

Answered: 1 week ago

Question

Define Scientific Management

Answered: 1 week ago