User Account

All Pages

Complete the purchases budget worksheet

Assignment Help Managerial Accounting
Reference no: EM131280780

A relatively new company, Wine To End Whining, Inc., has determined they need to engage in a budgeting process as part of their new strategic plan. The Company has asked you to provide the following items for the months of January, February, and March of 2017: A) a Purchases Budget; B) a Cash Budget; and C) a Budgeted Income Statement.

They have provided you with the planning document below and also, with their December 31, 2016 Balance Sheet. Please complete the three items requested on Worksheet Tabs A, B, and C of this Workbook for Module 7 Assignment 1.

A. Based on the information available to you, complete the Purchases Budget worksheet below. Check figures are: January Budgeted Purchase for Next Month Sales = $132,470; March Inventory Needed to be Available during Current Month = $194,090.

B. Based on the information available to you, complete the Cash Budget worksheet below. Check figures are: January Cash Receipts = $208,800; February Cash Disbursements = $204,259; March Ending Cash Balance = $114,679.

C. Based on the information available to you, complete the Budgeted Income Statement worksheet below. Check figures are: January Budgeted Gross Margin = $77,000; February Budgeted Operating Income = $10,710; March Budgeted Net Income = $4,242.

Attachment:- Workbook.xlsx

Verified Expert

The solution is in relation to concepts of budgeting . In part A purchase budget has been prepared. The solution to part b relates to preparation of cash budget. And in part C income statement has been prepared for Wine to End Whining Inc. All the answers match with check figures.

Reference no: EM131280780

Questions Cloud

Explain cultural beliefs and biases : Explain cultural beliefs and biases utilizing a sociological lens
Pregnant woman be punished for exposing : Read Issue 9 from Unit 3 in the Kaebnick textbook, "Should a Pregnant Woman Be Punished for Exposing Her Fetus to Risk?" Assume that you are a healthcare administrator, and you find yourself dealing with this exact issue regarding a patient giving..
Compare reformed christian and early modern bodies politic : For Short Paper, compare the Reformed Christian and Early Modern Bodies Politic. Where were they healthy and where were they sick?
Statement that the law is the floor of moral conduct means : Which of the following statements about moral standards is not true? The statement that the law is the floor of moral conduct means that.
Complete the purchases budget worksheet : MFE 6100 -Based on the information available to you, complete the Purchases Budget worksheet below. Check figures are: January Budgeted Purchase for Next Month Sales = $132,470; March Inventory Needed to be Available during Current Month = $194,09..
Plot the output signal to noise ratio as a function : Plot the output signal to noise ratio as a function of the input signal-to-noise ratio, both ratios being expressed in decibels.
What is modern secular political theory : What is Modern Secular Political Theory? Give at least 2 examples of Modern Secular political theorists and describe how they do political theory.
Find the torque needed to hold the manifold stationary : Determine the torque needed to hold the manifold stationary. What would the angular velocity of the manifold be if the resisting torque is negligible?
Why black lives do not matter : Why black lives don't matter and about the violence it has brought and i need some questions to ask the other side of the debate (hard questions to make them look bad). I'm not racist but that's just what I have to do.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd