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

07/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: Desired ending inventory Total needs Less: Beginning inventory Required Production Annin Flagmakers Direct Materials Budget (US$) April May Required production in units Raw materials per unit (lbs.) Production needs (lbs.) Add: Desired ending inventory Total needs Less: Beginning inventory Raw materials to be purchased Cost of raw materials Total Cost of Raw Materials June Annin Flagmakers Schedule of Expected Cash Disbursements for Material (US$) April May June Accounts payable Beginning balance April purchases May purchases June purchases Total Cash Disbursements for Materials Accounts Payable as of June 30 Annin Flagmakers Direct Labor Budget (US$) April May June Units to be produced Direct labor hours per unit Total direct labor hours needed Direct labor cost per hour Total Direct Labor Cost Budgeted direct labor hours Variable MOHD rate Total variable MOHD Fixed MOHD expense Total MOHD expense Less: Depreciation Cash Disbursements for MOHD MOHD rate Absorption cost per unit Direct materials Direct labor Manufacturing overhead Unit Product

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:

Top Academic Tutor
Assignments Hut
Financial Assignments
Academic Mentor
Coursework Helper
Essay & Assignment Help
Writer Writer Name Offer Chat
Top Academic Tutor

ONLINE

Top Academic Tutor

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

$27 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

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

$46 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

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

$24 Chat With Writer
Academic Mentor

ONLINE

Academic Mentor

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$41 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

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

$24 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

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

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

Invensys climate controls plymouth - 2012 nfpa 99 power strip requirements - Social stratification - The social responsibility of business is to increase its profits - To determine the true cash balance - A low cost leader's basis for competitive advantage is - 5 hanslow way taylors lakes - It research analyst job description - Ashworth sterile processing - Department 56 village animated rockefeller plaza skating rink - Introduction to policing Assignment #2 - Flames and dangling wire analysis - The sum of ten and the quotient of a number xxx and 666. - Microeconomics essay assignment - M km cm mm - Which of the following correctly describes the accounting treatment for interest payable? - Graham v connor pdf - Lord's day observance society - Cmpe3 - Sociogram observation in childcare example - Criminal Mind - Risk management? - M1a1 abrams technical manual - Tennis steps to success - Jitterbug perfume analysis - WEEK3-ResearchPaper-Data Science & Big Data Analy - International 5 - A 23.74 ml volume of - Systems analysis and design with uml 5th edition pdf - The columbian exchange crash course answers - Emc unity nas capabilities - Networking and marketing strategies for nurse practitioners - Discussion Due Tomorrow - Addicted and Functional Alcoholism - Red seal mechanic test - Capstone Research Paper - Unconventional approach to painting luncheon on the grass - Formula of curved surface area of right circular cone - Dc busbar sizing calculation - Thomas hill green might agree with which of the following? - Parable of sadhu case analysis - Saving private ryan movie questions answers - Nova mind of a rampage killer worksheet answers - CYS-D-14 - Nutrition feeding and eating ati - Symptoms of msg reaction - Media ethics issues and cases pdf - Arrest to Pretrial - Introduction to the middle ages worksheet - The mask you live in documentary questions - Hidden rules and expected and unexpected behaviors - Capital e with spanish accent - What cell part closely stacked flattened sacs plants only - Desert places literary devices - Big Data analytist - Tata group contribute annually for social welfare activity - Unit 2 Advance Business Statistics - Onslow co purchases a used machine for - NEEDS A General Chemistry II EXPERT! - Donahue angry white men - Tina jones abdominal objective data - Monash exam timetable release date - Laucke scone mix woolworths - BUS 660 WEEK 1 DISCUSIONS 1 &2 - Verizon fios store pawtucket ri - Forensic files prints among thieves worksheet answers - Analysing and visual data - Hyundai imax interior dimensions - Discussion - What type of demand elasticity is coca cola - Cuso4 + bacl2 precipitate - Brisbane city council subdivision and development guidelines - Utilitarianism's fundamental insight is that we should decide what to do by: - Business statistics for contemporary decision making 9th edition - Design a journal bearing for centrifugal pump - Compressor bleed valve operation - Introduction to Criminology. - 515 bus timetable ipswich - What does cross burning mean - Arb canopy fitting instructions - Report - If i were a boy just for a day - Need help in US History quiz as fast as possible and i need some that is good in us history. - Information Governance Metrics - #14 - Smoke detector dust cover home depot - Educational plan for a school - Firestone ethical issues - Con ecmu sms 1 - 23 dbm to mw - Shaft and hole tolerance - Health and policy 5-1 Discussion: Fraud and Abuse Regulation - The beauty myth quote - How to integrate product of two functions - Timberjack parts case study - Electronic reserve readings university of phoenix - Strayer outline - Below are incomplete financial statements for cyclone inc - Maths methods 3 4 - Order 2271967: Radical Design of Business