There is ACC 206 Week 5 Chapter 22 P 22-22A Exel in this pa

There is ACC 206 Week 5 Chapter 22 P 22-22A Exel in this pack P22-22A Preparing an operating budget [30 min] Thumbtack’s March 31 2012 budgeted balance sheet follows: The budget committee of Thumbtack Office Supply has assembled the following data. a. Sales in April were $40000. You forecast that monthly sales will increase 2% over April’s sales in May. June’s sales will increase 4% over April’s sales. July’s sales will increase 20% over April’s sales. Collections are 80% in the month of sale and 20% in the month following sale. b. Thumbtack maintains inventory of $11000 plus 25% of the COGS budgeted for the following month. COGS = 50% of sales revenue. Purchases are paid 30% in the month of purchase and 70% in the month following the purchase. c. Monthly salaries amount to $7000. Sales commissions equal 5% of sales for that month. Salaries and commissions are paid 30% in the month incurred and 70% in the following month. d. Other monthly expenses are as follows: Requirements 1. Prepare Thumbtack’s sales budget for April and May 2012. Round all amounts to the nearest $1. 2. Prepare Thumbtack’s inventory purchases and cost of goods sold budget for April and May. 3. Prepare Thumbtack’s operating expenses budget for April and May. 4. Prepare Thumbtack’s budgeted income statement for April and May. Note: We recommend you solve this and the related problems (P22-23A and P22-24A) using Excel templates that you create.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Do you need an answer to this or any other questions?

We are here to help you

Answers

Related Questions

Political Science : Black Hawk Down...

Running head: BLACK HAWKBlack HawkInstitutionCourseDateBLACK HAWK2Black Hawk DownThe Black Hwak Down was directed by Ridley Scott in 2001. The 29 part...

English : Privacy Concerns Dead Or Misunderstood...

Running head: PRIVACY CONCERNS1Privacy ConcernsNameInstitutionPRIVACY CONCERNS2Privacy Concerns, Dead or Misunderstood? The Perceptions of Privacy amo...

Business : Answer...

Running head: INVENTORY EVALUATION METHODS: FIFO AND LIFOInventory Evaluation Methods: FIFO and LIFONameInstitutionCourseDate1INVENTORY EVALUATION MET...

Writing : How Are Myths...

Insert Surname 1Students NameProfessors NameCourse Name and NumberDateHow are myths, fables, legends, and tall tales different from one another? Cite...

Health & Medical : Country Health Care Japan....

Running head: JAPAN HEALTH CARE1Japan Health CareNameInstitutionJAPAN HEALTH CARE2Japan Health CareThe health system of Japan is organized in a way th...

Engineering : Matlab Report...

Question 1MatLab Codeclear all;T =275:1:500;k = 1.38*10^(-23);z = 1.609*10^(-19);ni_si = (9.15*10^(19)).*((T./300).^2).*exp(-0.5928*z./(k.*T));ni_Ge =...

Business : Strategy Implementation Evaluation And...

Implementation of Strategies For BoeingCompanyThe Boeing CompanyStudents NameUniversity AffiliatedDateIntroductionThe Boeing company manufactures airc...

Health & Medical : Good Habits...

GOOD HABITS, CRITICALTHINKING[Document subtitle]MARCH 30, 2017Critical ThinkingThe scholarly attributes connected with a cultivated critical thinker t...

Writing : 6288133 Bus 1...

NIKE AND ADIDASComparative Report ofNike and AdidasOrganisationName12th July 2010This paper bring into picture differences in the management and perfo...

English : Hardy45...

1878THE RETURN OF THE NATIVEThomas HardyHardy, Thomas (1840-1928) - English novelist who initially wanted to be a poet butturned to novel writing when...

Economics : Financial And Monetary System S...

Running head: FINANCIAL AND MONETARY SYSTEMSFinancial and monetary systemsStudents NameInstitutionDate1FINANCIAL AND MONETARY SYSTEMS2Financial and mo...

Health & Medical : Business Impact Analysis 1...

BusinessImpactAnalysisInsert Presenter NameProfessors NameCourse TitleDateIntroduction BusinessImpact Analysis (BIA)- determines andevaluate any futur...

Health & Medical : Emotional Intelligence 2...

Running head: EMOTIONAL INTELLIGENCEEmotional IntelligenceNameTutorInstitutionCourseDate1EMOTIONAL INTELLIGENCE2IntroductionIn general, emotional inte...

Health & Medical : Long Term Care In The Us...

LONG-TERM CARE IN THE US1Long-term Care in the USNameInstitutional AffiliationLONG-TERM CARE IN THE US2IntroductionLong-term care is a kind of service...

Business : Organizational Leadership And Success...

Running Head: ORGANIZATIONAL LEADERSHIP AND SUCCESSOrganizational Leadership and SuccessName:Institution:1ORGANIZATIONAL LEADERSHIP AND SUCCESS2Organi...

History : History...

StudentProfessorCourse DetailsDate of SubmissionDiscussion QuestionsHow did the historical path to state-building differ between the MENA states and E...

Psychology : Human Personality...

Running head: HUMAN PERSONALITY1Human personalityNameInstitutionCourseTutorDateHUMAN PERSONALITY2Human personalityHuman Personality refers to the char...

Business : The Boeing Company Is The Top And Leadi...

RUNNING HEAD: THE BOEING COMPANYThe Boeing CompanyStudents NameUniversity AffiliatedDate:1THE BOEING COMPANY2The Boeing CompanyThe Boeing Company is a...

Business : Lexis Nexis Database...

Name 1NameProfessors NameCourse TitleSubmission DateLexis Nexis Case Brief; Securities and Exchange Commission v. Radius Corp.Lexis Nexis 119381Petiti...

Writing : Artists Paper.docx Rev 1...

Surname1NameInstructorCourseDateIntroductionThe three artists explored were Jay-Z, 50 Cent and Nas who are popular American artistsin the music indust...

History : Islam Final...

1StudentProfessorCourse DetailsDate of submissionIslam and politicsThe Islamic world has been identified as a religion that is commonly involved in ar...

Health & Medical : Nursing Competency...

Running Head: NURSING COMPETENCIESNursing CompetenciesNameCourseTutorDate1NURSING COMPETENCIES2Nursing CompetenciesThe competency of the health workfo...

Management : Management Gaming Operations...

SURNAME 1NameCourseInstructorDateManagement Gaming OperationsThe major goal of slot machines is to ensure that players receive entertainment whileplay...

Computer Science : Finalsecurity...

Running head: SECURITY TOPIC1STOW: System SecurityNameInstructorCourseDateSECURITY TOPIC2There has been a rise in security related cases that are spec...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it