CASE 2: CASH RECEIPTS ABC Company is preparing its cash budget for the next month. The accounts receivables at the beginning of the month is P100,000. The budgeted sales for the month is P500,000. Based on the sales projections, 80% of the budgeted sales will be on credit. Credit customers usually pay the following month. Required: What are the budgeted sales receipts from customers for next month?

CASE 2: CASH RECEIPTS ABC Company is preparing its cash budget for the next month. The accounts receivables at the beginning of the month is P100,000. The budgeted sales for the month is P500,000. Based on the sales projections, 80% of the budgeted sales will be on credit. Credit customers usually pay the following month. Required: What are the budgeted sales receipts from customers for next month?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 39P

See similar textbooks

Similar questions

A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.
The cost data for Evencoat Paint for the year 2019 is as follows: Month Gallons ofPaintProduced EquipmentMaintenanceExpenses January 110,000 $70,700 February 68,000 66,800 March 71,000 67,000 April 77,000 68,100 May 95,000 69,200 June 101,000 70,300 July 125,000 70,400 August 95,000 68,900 September 95,000 69,500 October 89,000 68,600 November 128,000 72,800 December 122,000 71,450 A. Using the high-low method, express the company’s maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Fixed cost $ Variable cost $
The below is an extract from the fixed asset register of ABC Ltd as at 31 December 2019Date of PurchaseCostuseful lifeLand1-Jan-306,000,000.000Building28-Feb-172,000,000.0020Vehicle:650,000.00Toyota Hilux1-Oct-19 350,000.005Ford Ranger30-Jun-17 300,000.005Furniture and Fittings1-May-20150,000.002Activities throughout the 2020 Financial Period:1. New Machinery have been purchased on 01 April 2020 at a Cost of N$ 4000,000. The machinery has been installed on the 15 April 2020 and was available for use on the 01 May 2020. Machinery is the only property plant and equipment of the company that is measured according to the revaluation method.1.1. On the 30th of October 2020 management decided to revalue the machinery due to a drastic decline in the revenue from sale of machinery produced inventory.Net replacement cost for the machine as at the 30th of October 2020 is N$2 000 000.2. The Toyota Hilux was involved in an accident on 1 October 2020 due to the floods and was written off by the…
A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.
How much influence can the employee requirements for one, two, or three days have on the weekly schedule in the employee scheduling example? Explore this in the following questions: a. Let Monday’s requirements change from 17 to 25 in increments of 1. UseSolverTable to see how the total number of employees changes.b. Suppose the Monday and Tuesday requirements can each, independently of one another, increase from 1 to 8 in increments of 1. Use a two-way SolverTable to see how the total number of -employees changes.c. Suppose the Monday, Tuesday, and Wednesday -requirements each increase by the same amount, where this increase can be from 1 to 8 in -increments of 1. Use a one-way SolverTable to -investigate how the total number of employees changes.
You own wheat warehouse with capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the table Month Selling price ($) Purchase prie ($) 1 3 8 2 6 8 3 7 2 4 1 3 5 4 4 6 5 3 7 5 3 8 1 2 9 3 5 10 2 5 The sequence of events during each month is as follows: a. You observe your initial stock of wheat. b. You can sell any amount of wheat up to your initial stock at the current month's selling price. c. You can buy(at the current month's buying price) as much wheat as you want, subject to the warehouse size imitation. Your goal is to formulate an LP that can be used to determine how to maximise the profit earned over the next 10 months and solve using Excel solver or AMPL
You have recently won the super jackpot in the WashingtonState Lottery. On reading the fine print, you discover that you have the following twooptions:a. You will receive 31 annual payments of $250,000, with the first payment beingdelivered today. The income will be taxed at a rate of 28 percent. Taxes will bewithheld when the checks are issued.b. You will receive $530,000 now, and you will not have to pay taxes on this amount.In addition, beginning one year from today, you will receive $200,000 each yearfor 30 years. The cash flows from this annuity will be taxed at 28 percent.Using a discount rate of 7 percent, which option should you select?
A bond has a face value of $1,000, an annual coupon rate of 3.70%, an yield to maturity of 7.4%, makes 2 (semi-annual) coupon payments per year, and 6 periods to maturity (or 3 years to maturity). Determine the duration of this bond. Notice that there is a function “Duration” in Excel, but you probably would like to check your answer with an analytical solution based on the specific duration formula. Note: This is an excel based assignment so please work it out on excel highlighting the formulas. thank you
A recently hired chief executive officer wants to reduce future production costs to improve the company's earnings, thereby increasingthe value of the company's stock. The plan is to invest $76,000 now and $58,000 in each of the next 6 years to improveproductivity. By how much must annual costs decrease in years 7 through 12 to recover the investment plus a return of 13% per year? The annual cost decreases by $....
An electronics firm has a contract to deliver thefollowing number of radios during the next three months;month 1, 200 radios; month 2, 300 radios; month 3, 300radios. For each radio produced during months 1 and 2, a$10 variable cost is incurred; for each radio produced duringmonth 3, a $12 variable cost is incurred. The inventory costis $1.50 for each radio in stock at the end of a month. Thecost of setting up for production during a month is $250. Radios made during a month may be used to meet demandfor that month or any future month. Assume that productionduring each month must be a multiple of 100. Given thatthe initial inventory level is 0 units, use dynamicprogramming to determine an optimal production schedule.
Nice-Fit is a (fictional) small business producing outfits for costume parties and specialoccasions. Custom designs can be tailored to a customer’s request. Tom and Ann are theowners of the company and source all the fabric, design the outfits and make the costumesthemselves. Tom and Ann keep spreadsheets with information on the material purchased andcostumes made, but they find it difficult to keep track of their products, raw materials, andsales. The raw materials are supplied from a fabric company in India, and the production takesplace in a manufacturing company in China. The clothing is sold at local weekend markets,sold, or rented through costume hire shops, and sold at their physical store. Tom and Annreceive a small percentage of the sales and rentals of their costumes from the hire shops.They have no information on customers other than those who request custom designsdirectly from them. In 2020, the Covid-19 pandemic had a major impact on global economies,businesses and how we…
During the first year software will be purchased from a reputable vendor for $3,000,000. An internal team aided by a hired consulting is also used. The payroll for the internal team is $500,000 for the first year and increases by $500,000 in years two and three. Also, $500,000 will be spent on consulting during the first year and $1,000,000 during each of years two and three. $2,000,000 will need to be invested in hardware during the second year and an additional $500,000 investment in hardware will be needed for year three. $200,000 in training will be needed the first year, $500,000 the second year, and $2,000,000 the third year. Management considers the expenditures for the first three years as investment in the system. Management estimates the operating cost of the system to be $2,500,000 (for personnel and other costs) in year 4 and to grow by 6% per year for years 5 through 10. The benefits are estimated to be $4,000,000 for year 4 and to grow by 30% per year for years 5…