Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Master budget template excel

21/04/2021 Client: muhammad11 Deadline: 2 Day

Requirements: 1) Using the data input provided, prepare AF’s master budgets in Excel. Do not hard-code numbers into the spreadsh except in the financing section of the cash budget. 2) Conduct a sensitivity analysis by decreasing sales 2%, and 5% for April through August. New sales levels are prov below. Adjust the financing and cash needs at these new sales levels. Your spreadsheet should have new tabs with th levels changed. Decreased by 2% 5% 2.450 2.375 5.880 5.700 2.940 2.850 2.450 2.375 1.960 1.900 Budgeted sales April (units) May (units) June (units) July (units) August (units) Expected 2.500 6.000 3.000 2.500 2.000 3) Watch the Annin Flagmaking video. www.youtube.com/watch?v=GPC1ZMOeAr8 Excel. Do not hard-code numbers into the spreadsheet, or April through August. New sales levels are provided ls. Your spreadsheet should have new tabs with the sales ?v=GPC1ZMOeAr8 Input Data (all currency in US$) Budgeted Sales April (units) May (units) June (units) July (units) August (units) Selling Price/Unit Expected 2.500 6.000 3.000 2.500 2.000 $120,00 Cash Collection Pattern Month of sale Following month Uncollectible 40% 55% 5% Cash Payments for Materials Month of purchase Following month 40% 60% Production Requirements Raw material per unit (lb.) Raw material cost per lb. Direct labor hours per unit Direct labor rate per hour Variable MOHD per direct labor hour Fixed MOHD per month Depreciation in fixed MOHD 5 $7,00 0,5 $40,00 $10,00 $57.950 $20.000 Selling & Administrative (S&A) Costs Variable S&A cost per unit sold Fixed S&A cost per month Depreciation in fixed S&A cost $1,25 $63.000 $10.000 Other Cash Outflows Cash dividends paid each month Equipment purchases May Equipment purchases June $15.000 $47.820 $154.600 Desired Ending Inventory Finished goods Raw materials Cash 20% 40% $30.000 Beginning Account Balances as of March 31 Cash Accounts receivable $37.745 $132.000 Finished goods inventory Finished goods cost per unit Finished goods inventory (units) Raw materials inventory Raw materials (lb.) Accounts payable Land Buildings and equipment Accumulated depreciation Common stock Retained earnings $30.750 $75,00 410 $32.200 4.600 $55.000 $520.000 $1.800.000 ($750.000) $500.000 $1.247.695 Cost of Goods Sold (FIFO) Beginning finished goods inventory Add: Cost of goods manufactured Good available for sale Less: Ending finished goods inventory Cost of Good Sold Sell Budgeted sales in units Variable S&A per unit Total variable S&A Total fixed S&A Total S&A expense Less: Depreciation Cash Disbursements for S&A Beginning Cash Balance Add: Receipts Cash collections Total Cash Available Less disbursements Direct materials Direct labor Manufacturing overhead Selling and administrative Dividends Equipment purchases Total Disbursements Excess (deficiency) of cash available Financing Borrowing Repayments Interest Total Financing Ending Cash Balance Net sales Less: Cost of goods sold Gross margin Less: S&A expenses Net operating income Less: Interest expense Net income Computation of Net Sales Sales Less uncollectible amounts Net Sales Current assets Cash Accounts receivable Raw materials inventory Finished goods inventory Plant and equipment Land Buildings and equipment Accumulated depreciation Total Assets Liabilities Accounts payable Stockholder's equity Common stock Retained earnings Yellow-use only cell references Blue-may type numbers here Annin Flagmakers Sales Budget (US$) April May June Budgeted sales (units) Selling price per unit Total Sales Annin Flagmakers Schedule of Expected Cash Collections (US$) April May June Accounts receivable Beginning balance April sales May sales June sales Total Cash Collections Accounts Receivable as of June 30 Annin Flagmakers Production Budget April May June Budgeted sales Add:

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Finance Professor
Engineering Exam Guru
Top Academic Guru
Fatimah Syeda
George M.
Helping Engineer
Writer Writer Name Offer Chat
Finance Professor

ONLINE

Finance Professor

I have read your project details. I can do this within your deadline.

$49 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

I have read your project details. I can do this within your deadline.

$36 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

I will cover all the points which you have mentioned in your project details.

$46 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

I have read and understood all your initial requirements, and I am very professional in this task.

$35 Chat With Writer
George M.

ONLINE

George M.

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$21 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

I will cover all the points which you have mentioned in your project details.

$29 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Nsw gvt household rebate - Density of water in lbm ft3 - Malcolm x literacy behind bars questions - Ravens vs crows australia - 1766 l32bxba analog input - Katrina turquotte ilford - Leslie marmon silko storyteller pdf - Dynamic and expressive techniques - Samling group share price - Primavera p6 activity report - Athlean x xero program pdf - Chapter 1 project demographics answers - Reinforcement lap lengths eurocodes - University of ottawa political science - A factory processes 1 560 ounces - Coca cola market penetration - W9 work assignment - Week 4 crisis intervention - Week 4 Report - Accessdata registry viewer download - Fenian rising 1867 - Case studiePYSC 430 Module/ - Sor 1 unit syllabus - Under armour challenging nike in sports apparel case analysis - In fusion cloning protocol - FIN/571: Corporate Finance - How to read german schematic - Public administration week 10 ass - Rowan of rin chapter summaries - Shetland times v wills - Stickup kid documentary - Philosophy here and now 3rd edition chapter 1 - Anti static materials list - The author to her book tone - Jack black saxophone tonight show - E thesis nit rourkela - Formula for aluminum phosphate - Rhetorical criticism sonja foss pdf - Isa in computer architecture - Financial managerial accounting 14th edition answers - Transition to work disability - Which of the following is most liquid - Functional patterns - Introduction speech about air pollution - Translate from Spanish to English - The decision to outsource opens the firm up to certain risks, among them _________ and ________. - Kant's Ethics and Our Duty- APA 1 PARAGRAPH with References - Density of salt lb ft3 - Dhashvanth name meaning in tamil - Clinging mollusc crossword clue - Sir lancelot rides slowly out of the castle - Succession management at general electric - 2 paragraphs 10/24/2020 - Calculate standard reduction potential - Unearthed arcana 5e feats - Fx2202 fire alarm manual - Brain candy questions and answers - Issa 12 week periodized training program - Declare a 8x8 two-dimensional array of strings named chessboard. - Www technologystudent com wood - Why are avocados expensive in australia - Summarize three important things with analyzing job performance as a manager to the employees, learning to understand diversity within the workplace, and handling work relationships with not being friends with someone on the job. - Cryptographic controls in our applications - Poli 330 week 3 quiz - Patton fuller community hospital networking project - One piece arc lengths - Discussion - How do enterprise systems help businesses achieve operational excellence - Text - Why are protists hard to classify - Creative writing character description examples - Food chain food web and ecological pyramids ppt - Business law - Torbay council parking permits - Project management - What does the suffix cyte mean - Vcaa 2020 chemistry exam - 1.6 mm corrosion allowance - Digital Systems Design & Forensics ((300 or more words per question) APA format with in-text citation and Zero plagiarism) - The walt disney company the entertainment king case analysis - Capsim marketing round 1 - Research paper on jeffrey dahmer - Yellow flame bunsen burner - Project - Web development company in bhopal - Week 4 Discussion - Kinetics lab report turnitin - WEEK 2 - Give me liberty an american history volume 2 chapter summaries - The major industries that developed in the south prior to 1900 included all of the following except - Project 1 - Persuasive piece of visual or mixed media rhetoric - Discussion - Charles starkweather family tree - Assignment 2: Practicum–Week 1 Journal Entry - The glass castle questions and answers - Engr 436 - Marketing Plan - STATISTICS EXCEL: WEEK 3 URGENT! - Redox reaction examples everyday life