Prepare a cash budget for the month of july

Assignment Help Managerial Accounting
Reference no: EM131162736

Sushi House has budgeted sales revenues as follows: Credit sales: June $85,000, July $80,000, August $72,000. Cash sales: June $14,000, July $25,000, August $32,000. Total sales: June $99,000, July $105,000, August $104,000. Past experience indicates that 70% of the credit sales will be collected in the month of sale and the remaining 30% will be collected in the following month. Purchases of inventory are all on credit and 60% is paid in the month of purchase and 40% in the month following purchase. Budgeted inventory purchases are: June $45,000, July $43,000, August $40,000. Other cash disbursements budgeted: selling and administrative expenses of $14,000 each month, dividends of $30,000 will be paid in July, and the purchase of a computer in August for $3,000 cash. The company wishes to maintain a minimum cash balance of $20,000 at the end of each month. The company borrows money from the bank at 9% interest if necessary to maintain the minimum cash balance. Borrowed money is repaid in months when there is an excess cash balance. The beginning cash balance on July 1 was $25,000. All amounts borrowed during a month are borrowed on the first day. The loan balance as of July 1 is $26,000.

Instructions: Prepare a cash budget for the month of July. Incorporate into your solution appropriate schedules for expected collections from customers and expected payments for purchases of inventory.

Reference no: EM131162736

Questions Cloud

Structural-functional approach : Why do some people (especially when guided by the structural-functional approach) describe the family as "the backbone of society?" That is, what are the societal functions of families? To what degree could other social institutions (including gov..
Express the linear model coefficients in terms of a b and c : Transform this equation into a linear model, and express the linear model coefficients in terms of a, b, and c.
Types of economic systems : State the defining characteristics of two types of economic systems: capitalism and socialism. How do these systems compare in terms of (a) overall productivity, (b) resulting economic inequality
Explain the assertion made in the text : Explain the assertion made in the text that race is socially constructed. That is, explain what biological traits may be used in defining race, but why a biological approach cannot explain the reality of race in the United States. Provide examples..
Prepare a cash budget for the month of july : Sushi House has budgeted sales revenues as follows: Credit sales: June $85,000, July $80,000, August $72,000. Cash sales: June $14,000, July $25,000, August $32,000. Prepare a cash budget for the month of July
What can an elderly grandma macionis teach : What can an elderly Grandma Macionis teach us about living a life that does not strain the natural environment? In what specific ways has life changed since her time? How have these changes affected the environment? What are the chances of regaini..
Identify the paths and path project durations : Identify the paths and path project durations. -  Determine the critical path and the expected project completion time.
Carla wahburn case : Refer to the Carla Wahburn case in the textbook's website (www.routledgesw.com/cases). Think about and discuss with your peers what fields of social practice may come into play in services to Ms. Washburn. Gerentology is obvious, but there are oth..
Personal values and beliefs regarding ethnic : Use the Journal to evaluate and identify your personal values and beliefs regarding ethnic groups and minorities. This self-evaluation should be written in paragraph form with an Introduction, Body, and Conclusion.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Fixed- and variable- cost pools

Suppose one predetermined rate per copy was used to allocate all photocopy costs. What rate would be used and how much cost would be allocated to the Public Works Department in August?

  Total amount of overhead costs assigned to the deluxe model

What is the total amount of overhead costs assigned to the standard model and what is the total amount of overhead costs assigned to the deluxe model?

  How can chemex protect itself against transaction exposure

Can Chemex eliminate its operating exposure by hedging its position every time it makes a foreign sale or by pricing all foreign sales in dollars? Why or why not?

  The following selected information is from ellerby company

1.The following selected information is from Ellerby Company's comparative balance sheets.

  Five star tools is a small family owned firm

Explain why the cutting department should cut back production from 700 items per hour to 600. Further, explain why if the cutting department does cut back, as it should, it is likely to have an unfavorable labor efficiency variance.

  Prepare only the operating activities section

It also reports $80,000 depreciation expense and a $20,000 gain on the sale of machinery.

  Prepare the journal entry or entries with explanations

Prepare the journal entry or entries, with explanations, that should be recorded on December 31, 2011, by Ludwick. (Prepare the lease amortization schedule for all five payments.)

  Kelly company sells its only product

The contribution margin is: A) $6 per unit B) $4.50 per unit C) $5.50 per unit D) $4 per unit

  Identify each expense as fixed-variable,or mixed

Identify each expense as fixed, variable, or mixed and prepare a contribution margin income statement based on a volume of 5,000 windows.

  Question on sampling from managerial perspective

Describe the importance of sampling from the managerial perspective. Give examples.

  Calculate the change in a batchs profits from the beginning

Assume that the batch productivity statistics are met by the end of the year. Calculate the change in a batch's profits from the beginning of the year to the end attributable to changes in materials and labor productivity.

  Consider the business application item

Consider the Business Application item "Using Statistical Analysis to Improve Profitability.

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!

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