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

Accounting excel project

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

I’m working on a Accounting exercise and need support.

need help to complete an excel project

cells should have formulas

please take a look at the attached excel file for instructions and requirement

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 Cost Annin Flagmakers Manufacturing Overhead Budget (US$) April

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:

Math Specialist
Top Essay Tutor
Accounting Homework Help
Assignment Helper
Helping Engineer
High Quality Assignments
Writer Writer Name Offer Chat
Math Specialist

ONLINE

Math Specialist

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

$36 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

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

$19 Chat With Writer
Accounting Homework Help

ONLINE

Accounting Homework Help

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

$39 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

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

$18 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

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

$31 Chat With Writer
High Quality Assignments

ONLINE

High Quality Assignments

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

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

Oxalic acid with sodium hydroxide - Peter pan and wendy play script pdf - Vd PP OP - Operational Excellence discussion - Mba 503 milestone 2 - P song jolly phonics - Kinetic bike trainer maintenance - 698wk1 - Camberwell high school fees - Boundstone community college teachers - Math - Personal helpers and mentors - Http coolclimate berkeley edu calculator - Lady manners sixth form - Breckland council bin collection - How to make a paper lifeboat - Normal probability plot minitab - How strategic fit is achieved in scm - If 1200 cm2 of material is available - Heart of darkness apocalypse now comparison - Brisbane to keppel yacht race - Module 02 Lab 01 - Coffee Problem - Igcse biology reproduction past papers - Absolutely Zero PLAGIARISM - Moodle bcu ac uk - Is the handmaid's tale a feminist book - Effects of social networking sites ppt - The two-step approach to direct marketing - Islam empire of faith video questions answers - Week 10 Discussion - Annotated Bibliography - Dfs g plan flair - Peer graded assignment the five layer network model - What is an example of a folktale story - Avon case study - In which of kubler-ross's stages would someone who feels exhausted and has a sense of futility be? - How salt affects the freezing point of water - Capstone - 6610 carol court granbury tx - Classify database technologies and healthcare information systems used to manage data and information - My cafe watson hypnosis answer - Samsung ssd serial number decoder - Is 27 a perfect square - Cultural diversity - What is deliverable percentage in stock market - Criminal justice - Royal jelly roald dahl - Executive Program Practical Connection Assignment - Information Governance (ITS-833-M23) - Full Term - St stithians past papers grade 11 - Comparison of the DNP and PhD Roles in Nursing - The new york house of refuge - Oecd well being framework - Financial Statement Analysis - Sample case brief using irac - How many core electrons are in a chlorine atom - Gregorian chant mass settings - Christian bale housing market movie - Broadmeadows multicultural early learning centre - Palomar health pathmaker - Devon bishop age 45 is single - Practical Connection Assignment Operational Excellence - Ammonia gas and hydrogen chloride gas equation - Due Tonight - National bohemian bottle cap answers - Speaking Assignment - American electrical wiring colours - Complementary and supplementary angles worksheet kuta - Find the indicated area under the standard normal curve - Three Dimensions of Risk Management - Away from home rate youth allowance - Allan hancock blackboard - Bag and tag forensics - Interpreter of maladies essay - Change passport details cebu pacific - Khp and naoh titration equation - What are the 10 principles of catholic social teaching - Amberley school west sussex - Hash house harriers down down song - Amnion and chorion ultrasound - IT Doesn’t Matter - Unsw law cover sheet - Mutt and jeff on strike 1920 - Route 53 interview questions - Khan academy ancient china - How to find homework answers online - Analysis of a Pertinent Healthcare Issue - PSY330AssignmentsWeek 5 - Final Paper - Tigh nan saor plockton - Family Information Night Presentation and Communication Plan - Sweet leaf bath co case analysis - Develop a trend line for the demand for fertilizer - According to piaget accommodation occurs when individuals - What healthcare organizations collect uhdds data - Ansul r 102 cartridge - Behind the beautiful forevers full text pdf - Dfid sustainable livelihoods guidance sheets - What you pawn i will redeem thesis statement - Poverty cycle ib economics - Industry-average ratios - Microsoft - Unisa city west map