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

  Which categories are used to determine factory overhead

which are NOT used to determine Factory Overhead and why. which categories ARE used to determine Factory Overhead.

  Prepare a differential analysis report

Prepare a differential analysis report, dated April 21 of the current year, on the proposal to sell at the special price and prepare a differential analysis report, dated March 12 of the current year, on the decision to make or buy Part Q.

  What is the amount of annual cash flows

1. What is the amount of annual cash flows that Polaris must earn from these projects to have a 10% internal rate of return? (Hint: Identify the ten-period, 10% factor from the present value of an annuity table, and then divide $2.12 million by the f..

  Will you perceive the allocated service department

In performing incremental analysis related to expanding or contracting her business, will the president of Auburn Business Banking tend to overestimate or underestimate incremental costs? Explain.

  What is the rule for classifying a liability as current

What is the rule for classifying a liability as current? Is accounts payable a current or non-current liability? Why are unearned revenues classified as liabilities?

  Consider that you are audit senior in an accounting firm

consider that you are audit senior in an accounting firm. your firm has recently won an audit for a company. thus your

  Compute the average price per teddy bear needed

Provide a formal income statement with appropriate headings to show the operating income for the year 2011 under absorption costing approach.

  Goose down is used in a wide variety of products

Goose down is used in a wide variety of products, including jackets, bedding, and pillows.) In recent years, the cost of down has been increasing. For example, in October 2010, Lands' End, a retailer of clothing and bedding items, was paying about $1..

  What is the optimized monthly profit

In order to maximize weekly profits, how many pounds of each ingredient should be purchased - How much should Snoo be willing to pay for an additional pound of ingredient C to raise total profit?

  Milo company manufactures beach umbrellas the company is

milo company manufactures beach umbrellas. the company is preparing detailed budgets for the third quarter and has

  Complete the personal organizers or sell them

Determine whether Data Point, Inc. should complete the personal organizers or sell them in their current state.

  Journalize the adjusting entries and create t accounts

Journalize the adjusting entries and create T accounts for all accounts used in part Enter the trial balance amounts into the T accounts and post the adjusting entries.

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