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 ofthe following funds ofchessie city

Which ofthe following funds ofChessie City would be consolidated to form the governmental activities column in the City's government-wide tmancial statements? a) Its general fund, special revenue fund, and agency fund

  Does either form dominate from a tax perspective

1. Does either form dominate from a tax perspective?

  Calculate abc-based services costs for the tfc business

Calculate ABC-based services costs for the TFC business and calculate the distribution services costs for "Customer A" and "Customer B." What inference do you draw about the profitability of these two customers?

  A loosely formed voluntary association

Twelve individuals agreed to sponsor and promote a group of Little League baseball teams called the Golden Spike Little League. The league was a loosely formed voluntary association without any legal identit

  Explain how the inventory loss would be reported

Explain how the inventory loss would be reported when the periodic inventory system is used.

  Explain capital evaluation methods strengths and weaknesses

Select one of the capital investment evaluation methods describedt. Fully explain the capital evaluation method's strengths and weaknesses. Take a position and defend the use of your selected method.

  Calculate the impact of the exhibit on company profit

Calculate the impact of the exhibit on company profit. Should the company exhibit at the home show?

  Development of a conceptual framework

Why might a company want to engage in off-balance sheet financing and what are the four options that manufacturing and service companies have to transform breakeven or loss customers into profitable ones?

  Cash conversion cycle-working capital management

What is the significance to working capital management of matching sales and production? What is the significance to working capital management of matching payables with receivables?

  Should super fresh make the investment in the new business

Assume that Super Fresh has decided to limit its analysis to seven years. Calculate the net present value of the new business using a 14 percent required rate of return. Should Super Fresh make the investment in the new business?

  Prepare a journal entry to close the variance

Prepare a journal entry to close the variance accounts at Bell Computers .Assume that the total variance is not material and is closed to cost of goods sold.

  Determining costing systems

Which costing system would be more efficient when direct labor costs and direct materials are low, and overhead is high and why? Explain how the supply chain and the macroeconomic environment of the health care business fit in with your calculations?

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