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 managerial accounting

23/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:

Ideas & Innovations
Quick N Quality
Financial Hub
Essay & Assignment Help
Fatimah Syeda
Top Essay Tutor
Writer Writer Name Offer Chat
Ideas & Innovations

ONLINE

Ideas & Innovations

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

$39 Chat With Writer
Quick N Quality

ONLINE

Quick N Quality

Give me a chance, i will do this with my best efforts

$32 Chat With Writer
Financial Hub

ONLINE

Financial Hub

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$21 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

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

$19 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

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

$39 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

Give me a chance, i will do this with my best efforts

$30 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

Lockheed martin systems engineer - How are standard costs developed - Porter Five Forces Analysis Paper Draft - Forensic design assessments - Ethical issues uber - Courtyard creations replacement cushions for orbit lounger - Dq - Is no2f polar or nonpolar - Artfact - Compare and contrast the elements of a life review with those of ordinary remembering - What passage of scripture gives insight into the routine activity of the early church? - Business Intelligence-Report 2 - Http www youtube com watch v vdh7mngntni - Three basic structures in programming - What is the revision stage of policy process - Mr bean pushes woman's face - Whittlesea council register dog - Vl calais lower door moulds - Final project busi 201 - Document analysis questions answers - City and guilds functional skills 3748 - State patrol ticket processing system - Tcs leadership development program - Kotter’s 8-Step Change Model Chart - Principles of management bateman snell - Social work professional values and ethics - Ranson attack assignment - Short discussion (200 words) - Jb hi fi pure digital radio - Challenger institute of technology rockingham - Assignment Due 10/10/2020 200-350 words - Discussion 3: sleep disorders - Using the enthalpies of combustion for c4h4 - Gcu mat 144 module 1 homework - Ku children's services pay rates - 5 principles of body mechanics - Timeline - Z score statcrunch - Performance lawn equipment case - Legal Compliance(Go through the PDF ) - Journal Reflections - 2 pages - Which artifact depicts the unification of upper and lower egypt - Organelles and illness worksheet answers - The dark child chapter 1 summary - 1 - buena gente rewrite each sentence, replacing the direct objects with direct object pronouns. - Order # 9358 - Aunty joan's gourmet toffee stockists - Life of pi discussion questions - When i heard the learn'd astronomer meaning - Organizational behavior chapter 4 personality and values - Rule of six walter murch - Paper - Me3 assist the mechanic - Icare concept to interprofessional teams - How to win practice marketing game - Yolanda godbee - Petlogadmin thekennelclub org uk - Madagascar's age structure diagram ________ - What is stealth marketing course hero - The mass of a bowling ball is 7 - Gcwc the great canadian wiring company - Vodka cruiser vanilla pine lime - 2211 riverside drive unit 403 ottawa ontario k1h 7x5 - Walmart capstone simulation level 3 - Article Analysis,please add references and follow the template that I uploaded by 10/21/2020 at 4: 00 pm - Uber organizational culture case study - History of linguistics ppt - How to develop theoretical framework - Miele coffee maker expel air - Discussion question, 350 words and 2 references. (Abstract, Introduction, Results, and Conclusion) - The contorted realm map - Stephen robbins organizational behaviour ppt 13th edition - Uncle louie trick or treat - Nymph who loved narcissus - How to do standard deviation on a sharp calculator - Sherbourne road medical clinic - Commitment to academic excellence - Worldview and nursing process personal statement - The par value of common stock represents - Khc8h4o4 naoh - Plot the data in table 5.1 on the graph below - Check list for job safety analysis - North richmond community health ceo - Dmaic project report - Advantages and disadvantages of computer forensics - Practice with taxonomy and classification answer key - Chicken wings parts names - Thrt c - Philosophy (Predicate Logic Error) - Aqualisa quartz simply a better shower case study - The power of logic 5th edition answer key - WEBAssignment - Week 5 Discussion 1 Working Together to Achieve a Common Goal - How to recover from emergency loan capsim - Business Essay - Adobe certified associate program - Glasney student village penryn - SLP--ACCOUNTING COST SYSTEMS AND COST BEHAVIOR - What is the calorimeter constant of a styrofoam cup - Marketing Management