Order Now

MasterBudgetTemplate_StudentVersion_ACCU20212.xlsx

Homework Help

Master Budget P9-57

Master Budget (P9-63A) GRADING:
Student Name: HIDE/LOCK
CASH COLLECTIONS BUDGET:
Cell Ref Correct answer Correct/Incorrect Points Awarded
SALES BUDGET: D14 24,000 INCORRECT 0
Jan Feb Mar Quarter D15 49,000 INCORRECT 0
Budgeted unit sales D16 73,000 INCORRECT 0
Selling price per unit E14 27,600 INCORRECT 0
Total Sales E15 56,000 INCORRECT 0
E16 83,600 INCORRECT 0
F14 29,700 INCORRECT 0
SCHEDULE OF EXPECTED CASH COLLECTIONS: F15 64,400 INCORRECT 0
Jan Feb Mar Quarter F16 94,100 INCORRECT 0
Cash sales G16 250,700 INCORRECT 0
Credit sales TOTAL 0
Total Cash Collections
PRODUCTION BUDGET:
PRODUCTION BUDGET: D23 10,300 INCORRECT 0
Jan Feb Mar Quarter Apr D24 2,000 INCORRECT 0
Budgeted unit sales D25 8,300 INCORRECT 0
Add desired ending inventory E23 11,675 INCORRECT 0
Total needs E24 2,300 INCORRECT 0
Less beginning inventory E25 9,375 INCORRECT 0
Units to produce F23 12,325 INCORRECT 0
F24 2,475 INCORRECT 0
DIRECT MATERIALS BUDGET: F25 9,850 INCORRECT 0
Jan Feb Mar Quarter Apr G25 27,525 INCORRECT 0
Units to be produced TOTAL 0
Multiply by: Quantity of DM needed per unit
Quantity of DM needed for production
Plus: Desired ending inventory of DM DM BUDGET:
Total quantity of DM needed D33 18,475 INCORRECT 0
Less beginning inventory of DM D35 16,815 INCORRECT 0
Quantity of DM to purchase D37 33,630 INCORRECT 0
Multiply by: Cost per pound E33 20,720 INCORRECT 0
Total cost of DM purchases E35 18,845 INCORRECT 0
E37 37,690 INCORRECT 0
F33 21,580 INCORRECT 0
CASH PAYMENTS FOR DM PURCHASES: F35 19,610 INCORRECT 0
Jan Feb Mar Quarter F37 39,220 INCORRECT 0
Accounts payable G37 110,540 INCORRECT 0
Januray purchases TOTAL 0
February purchases
March purchases
Total cash payments CASH PAYMENT FOR DM PURCHASES
D46 49,126 INCORRECT 0
E46 34,442 INCORRECT 0
CASH PAYMENTS FOR DIRECT LABOR: F46 37,996 INCORRECT 0
Jan Feb Mar Quarter G46 121,564 INCORRECT 0
Direct labor TOTAL 0
CASH PAYMENT FOR DIRECT LABOR
D51 996 INCORRECT 0
CASH PAYMENTS FOR MANUFACTURING OVERHEAD E51 1125 INCORRECT 0
Jan Feb Mar Quarter F51 1182 INCORRECT 0
Variable manufacturing overhead costs G51 3303 INCORRECT 0
Rent (fixed) TOTAL 0
Other MOH (fixed)
Total cash payments CASH PAYMENT FOR MOH
D60 17960 INCORRECT 0
E60 19250 INCORRECT 0
CASH PAYMENTS FOR OPERATING EXPENSES F60 19820 INCORRECT 0
Jan Feb Mar Quarter G60 57030 INCORRECT 0
Variable operating expenses TOTAL 0
Fixed operating expenses
Total cash payments CASH PAYMENT FOR OPERATING EXPENSES
D67 9000 INCORRECT 0
E67 10200 INCORRECT 0
CASH BUDGET F67 10900 INCORRECT 0
FOR THE THREE MONTHS ENDING March 31 G67 30100 INCORRECT 0
Jan Feb Mar Quarter TOTAL 0
Cash balance, beginning
Add collections from customers
Total cash available CASH BUDGET
D75 77500 INCORRECT 0
Less cash payments D84 82082 INCORRECT 0
DM purchases D91 9000 INCORRECT 0
Direct labor D93 4418 INCORRECT 0
MOH costs E75 88018 INCORRECT 0
Operating Expenses E84 87017 INCORRECT 0
Tax Payment E91 3000 INCORRECT 0
Equipment purchases E93 4001 INCORRECT 0
Total Disbursements F75 98101 INCORRECT 0
F84 85898 INCORRECT 0
Ending cash balance before financing F91 -7330 INCORRECT 0
Financing: F93 4873 INCORRECT 0
Borrowings G75 255200 INCORRECT 0
Repayments (enter as a neg. number) G84 254997 INCORRECT 0
Interest payments (enter as a neg. number) G91 4670 INCORRECT 0
Total financing G93 4873 INCORRECT 0
TOTAL 0
Cash balance, ending
BUDGETED MANUFACTURING COST PER UNIT MANUFACTURING COST PER UNIT
Charms: Review the information given about DM, DL, and MOH Charms: Hint: This is not a sum of the quarter. It is asking for the balance at the end of the quarter Charms: Hint: This is not a sum of the quarter. It is asking for the balance at the end of the quarter D98 4 INCORRECT 0
Direct materials cost per unit D99 0.12 INCORRECT 0
Direct labor cost per unit D100 1.2 INCORRECT 0
Variable manufacturing costs per unit D101 0.8 CORRECT 2
Fixed manufacturing overhead per unit 0.80
Charms: Amount given: based on $8,000 fixed ovh per month divided by approx. 10,000 units per month 		D102 6.12 INCORRECT 0
Cost of manufacturing each unit TOTAL 2
Martin Manufacturing
BUDGETED INCOME STATEMENT
FOR THE THREE MONTHS ENDED March 31
INCOME STATEMENT
Sales F108 271000 INCORRECT 0
Less COGS: F109 165852 INCORRECT 0
Gross profit F110 105148 INCORRECT 0
Less expenses:
Operating Expenses F112 30100 INCORRECT 0
Depreciation F113 4600 INCORRECT 0
Operating Income F114 70448 INCORRECT 0
Interest Expense F115 330 INCORRECT 0
Income tax expense Charms: Round number to the nearest whole dollar. (You can show your work in the cell next to this one or below). Charms: Hint: This is not a sum of the quarter. It is asking for the balance at the end of the quarter Charms: Hint: This is not a sum of the quarter. It is asking for the balance at the end of the quarter Charms: ENTER EXPENSES AS POSITVE NUMBERS F116 21035 INCORRECT 0
Net income F117 49083 INCORRECT 0
TOTAL 0
GRADING IS SHOWN TO THE RIGHT—> GRAND TOTAL GRAND TOTAL 2
Continue to order Get a quote
Place your order
(550 words)

Approximate price: $22

Recent Comments

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more