Each month showing budgeted cash disbursements

Assignment Help Financial Accounting
Reference no: EM131214377

Tilson Company has projected sales and production in units for the second quarter of the coming year as follows

Sales............... April 55,000 May 45,000 June 65,000

Production......... April 65,000 May 45,000 june 55,000

Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $110,000 per month. The accounts payable balance on March 31 totals $193,000, which will be paid in April. All units are sold on account for $16 each. Cash collections from sales are budgeted at 60% in the month of sale, 30% in the month following the month of sale, and the remaining 10% in the second month following the month of sale. Accounts receivable on April 1 totaled $520,000 $(100,000 from February's sales and the remainder from March).

Required:

a. Prepare a schedule for each month showing budgeted cash disbursements for the Tilson Company.

b. Prepare a schedule for each month showing budgeted cash receipts for Tilson Company.

Reference no: EM131214377

Questions Cloud

Markup percentages for total variable costs : Computing Markups The predicted 2009 costs for Osaka Motors are as follows: Manufacturing Costs Selling and Administrative Costs Variable $100,000 Variable $300,000 Fixed 230,000 Fixed 200,000 Average total assets for 2009 are predicted to be $4,000,..
Recorded by the lessor on this transaction : The cost of the equipment manufactured by Solitaire is $120,000 and the fair value is $190,008.49. Solitaire incurred initial direct costs of $50,000 associated with putting the lease deal together. The term of the lease is 10 years with annual payme..
Determine dollar sales volume required to earn monthly : The STC Supply manufactures memory cards that sell to wholesalers for $4.00 each. Variable and fixed costs are as follows: Variable Costs per card: Fixed Costs per Month: Manufacturing Direct materials $0.60 Direct labor 0.50 Factory overhead 0.50 $1..
Existing internal control system over cash admission fees : Lobs, Love & Lessons Tennis Club The Lobs, Love & Lessons Tennis Club is a large, regional chain of full-service tennis clubs that cater to the demographics of the region (about 60% of all adults are single in most locations). Assume that you are the..
Each month showing budgeted cash disbursements : Tilson Company has projected sales and production in units for the second quarter of the coming year as follows. Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 40% are paid in the month in which they ar..
Prepare budget showing quantity of switches to be purchased : A sales budget is given below for one of the products manufactured by the Key Co.: The inventory of finished goods at the end of each month must equal 20% of the next month's sales. On December 31, the finished goods inventory totaled 4,000 units. Ea..
What type of lease is this for talkaholics : Talkaholics Inc. leased a satellite transmission device from ACME Satellites on January 1, 2016. ACME paid $1,000,000 for the satellite which retails for $1,307,362. What type of lease is this for Talkaholics? Explain. Prepare the appropriate entries..
Payments of interest and amortization of discount : On January 1, 2010 Lurline Corporation issued ten-year, 8 percent bonds with a face value of $500,000. The semiannual interest dates are June 30 and December 31. Prepare entries in a journal form without explinations to record the bond issure on Janu..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Used in producing diagnostic electronic instruments

Assume a division of Hewlett-Packard currently makes 8,000 circuit boards per year used in producing diagnostic electronic instruments at a cost of $33 per board, consisting of variable costs per unit of $26 and fixed costs per unit of $7. Further as..

  Decision on proposal where contract price is lesser than

decision on proposal where contract price is lesser than variable costgenerators inc. produced emergency backup

  Prepare the reconciliation necessary to convert

Prepare the reconciliation necessary to convert from the fund balance reported in the governmental funds Balance Sheet to the net assets in the government-wide Statement of Net Assets.

  Veras taxable income

Vera’s taxable income is in the 35% tax bracket. Assuming Vera is itemizing deductions, is it more valuable for her to get a $2000 deduction or a $1800 credit

  Determine the dollar amount of the flexible budget

Actual costs incurred during the production of? 60,000 mattresses? were; direct? materials, $110,000; direct? labor, $60,000; variable? overhead, $100,000; and fixed? overhead, $97,000. If Take Eight evaluated performance by the use of a flexible? bu..

  Factory overhead is applied on basis of direct labor cost

Berg-Warner Automotive uses job costing in which factory overhead is applied on the basis of direct labor cost. Any overapplied or underapplied overhead is considered material. Calculate the firm’s predetermined factory overhead rate as a percentage ..

  What is balance of miles capital account at the end of yr

Each partner had a beginning capital balance of $120,000. Any remaining net income or net loss is shared equally. What is balance of Miles' Capital account at the end of the year after net income has been distributed?

  Complete the balance sheet at december

Complete the balance sheet using cash flow data Following is a partially completed balance sheet for Epsico, Inc. Complete the balance sheet at December 31, 2013.

  Cash flows from operating activities using indirect method

Prepare the cash flows from operating activities using the indirect method-Cash Flow from operating activities

  What is standard deviation of return on philippine market

What is the standard deviation of return on the Philippine stock market to a U.S. investor if the standard deviation of the local stock market is 24.8 percent.

  Show how to account for inventory transactions

(Learning Objective 1: Show how to account for inventory transactions)Journalize the following assumed transactions for The Soda Pop Company. Show amounts in billions.

  Calculate the average age of lozier inventory for 2010

Calculate the average age of Lozier's inventory for 2010 and 2011. Assume a 360-day calendar year.

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