Your company, Proxima, Inc, is one of the first companies in the US to make a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your company, Proxima, Inc, is one of the first companies in the US to make a successful covid vaccine. Although Proixma is primarily a research company and not a distributor, you do have a limited number of vaccine units available to sell to the government. Your supervisor, Alice, has requested that you put together a power point presentation that she can use to get the CEO up to speed on Proxima's projected number of vaccine units available for sale. Projected sales in units for the first 5 months of 2021 are: January 10,000 10,500 13,000 16,000 15,500 February March April May The following data pertain to production policies and manufacturing specifications followed by Proxima: a) Finished goods inventory on January 1 is 900 units. The desired ending inventory for each month is 20% of the next month's sales. b) Only two types of drugs go into the vaccines. The data on materials used are as follows: Direct material Part #REM20 Per-Unit Usage Unit Cost $4.00 Part #HCL19 3 $7.00 Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next month's production needs. This is exactly the amount of material on hand on January 1. c) The direct labor used per unit of output is one and one-half hours. The average direct labor cost per hour is $20.00 d) Overhead each month is estimated using a flexible budget formula. (Activity is measured in direct labor hours.) Fixed Cost Variable-Cost Component Component Supplies $1.00 $0.20 $1.10 Power Maintenance $12,500 $14,000 $45,000 $ 4,300 $86,000 Supervision Depreciation Тахes Other $1.60 e) Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Activity is measured in units sold). Variable Costs Fixed Costs $ 88,500 Salaries Commissions $1.40 Depreciation $ 25,000 Shipping Other $3.60 $1.60 $137,000 ) The unit selling price of one vial of the vaccination is $110. e) In February, the company plans to purchase land for future expansion. The land costs $68,000. h) All sales and purchases are for cash. The cash balance on January 1 equals $62,900. The firm wants to have an ending cash balance of at least $25,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Any cash borrowed must be borrowed in $1,000 increments and is repaid the following month, as is the interest due. The interest rate is 12 percent per annum. REQUIRED: Prepare a monthly operating budget for the first quarter with the following schedule: 1) Sales budget 2) Production budget 3) Direct materials purchases budget 4) Direct labor budget Your company, Proxima, Inc, is one of the first companies in the US to make a successful covid vaccine. Although Proixma is primarily a research company and not a distributor, you do have a limited number of vaccine units available to sell to the government. Your supervisor, Alice, has requested that you put together a power point presentation that she can use to get the CEO up to speed on Proxima's projected number of vaccine units available for sale. Projected sales in units for the first 5 months of 2021 are: January 10,000 10,500 13,000 16,000 15,500 February March April May The following data pertain to production policies and manufacturing specifications followed by Proxima: a) Finished goods inventory on January 1 is 900 units. The desired ending inventory for each month is 20% of the next month's sales. b) Only two types of drugs go into the vaccines. The data on materials used are as follows: Direct material Part #REM20 Per-Unit Usage Unit Cost $4.00 Part #HCL19 3 $7.00 Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next month's production needs. This is exactly the amount of material on hand on January 1. c) The direct labor used per unit of output is one and one-half hours. The average direct labor cost per hour is $20.00 d) Overhead each month is estimated using a flexible budget formula. (Activity is measured in direct labor hours.) Fixed Cost Variable-Cost Component Component Supplies $1.00 $0.20 $1.10 Power Maintenance $12,500 $14,000 $45,000 $ 4,300 $86,000 Supervision Depreciation Тахes Other $1.60 e) Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Activity is measured in units sold). Variable Costs Fixed Costs $ 88,500 Salaries Commissions $1.40 Depreciation $ 25,000 Shipping Other $3.60 $1.60 $137,000 ) The unit selling price of one vial of the vaccination is $110. e) In February, the company plans to purchase land for future expansion. The land costs $68,000. h) All sales and purchases are for cash. The cash balance on January 1 equals $62,900. The firm wants to have an ending cash balance of at least $25,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Any cash borrowed must be borrowed in $1,000 increments and is repaid the following month, as is the interest due. The interest rate is 12 percent per annum. REQUIRED: Prepare a monthly operating budget for the first quarter with the following schedule: 1) Sales budget 2) Production budget 3) Direct materials purchases budget 4) Direct labor budget
Expert Answer:
Related Book For
Introduction to Management Accounting
ISBN: 978-0133058789
16th edition
Authors: Charles Horngren, Gary Sundem, Jeff Schatzberg, Dave Burgsta
Posted Date:
Students also viewed these accounting questions
-
US Airways is one of the nations leading commercial air carriers, with hubs in Phoenix and Las Vegas. The following are some of the costs incurred by US Airways. For each cost, select an appropriate...
-
Although the United States is one of the worlds wealthiest nations, some of the federal governments budget decisions are severely constrained by scarcity. Can you think of one such decision that was...
-
One of the first human proteins cloned was interferon. Why would it be important to be able to produce interferon in a lab?
-
Suppose that there are two countries, A and B, and two goods, X and Y. Country A has a production possibility frontier (PPF) that is given by the equation X + Y = 100, while country B has a PPF that...
-
Japanese industry is often praised for its just-in-time inventory practice between industrial buyers and industrial sellers. In the context of the Days Receivables turnover in Exhibit 19.5, what is...
-
Determine the convergence or divergence of the sequence with the given nth term. If the sequence converges, find its limit. an = n 1 n!
-
1. Benzaquin had a radio talk show in Boston. On the program, he complained about an incident earlier in the day, in which state trooper Fleming had stopped his car, apparently for lack of a proper...
-
Here are comparative statement data for Prince Company and King Company, two competitors. All balance sheet data are as of December 31, 2014, and December 31, 2013. Instructions (a) Prepare a...
-
Suppose Fun N Games uses the perpetual inventory system and buys $160,000 of Connects toys on credit terms of 3/15, n/30. Some of the goods are damaged in shipment, so Fun N Games returns $16,500 of...
-
Imagine that Howard has asked you to write some queries to help him make better use of his data. For each information request below, write a single query that provides the answer set. When a task...
-
Brian is the IT professional at an electronics company. On a Labor Day weekend where they were offering special sales to customers in selected states, there were a number of complaints that the site...
-
Does the temporary difference give rise to a deferred tax asset? Explain.
-
AB Baking Co's value is $36 million if it is not liquidated, and $28 million if it is liquidated. The firm has $24 million in senior debt outstanding and $20 million in junior debt outstanding. it is...
-
What are the relationship between the marginal benefit, value, and demand? What is the relationship between individual demand and market demand? What is the consumer surplus? How is it measured?
-
Does the Banco de Mxico ( bank of Mexico) have deposit insurance for its customers? If so, up to what amount? provide reference.
-
Is goodwill considered as asset for financial planning?
-
In a nutsell, what does stakeholder theory argue? The goal of the company is to maximize the value of the firm, e.g. increase the share price as much as possible. The goal of the company is to create...
-
Let X be a random variable taking on values a1, a2, . . . , pr with probabilities p1, p2, . . . , pr and with E(X) = μ. Define the spread of X as follows: This, like the standard deviation, is a...
-
If DCF approaches are superior to the payback and the accounting rate-of-return methods, why should we bother to learn the others? All it does is confuse things. Answer this contention.
-
Refer to the Lopez Plastics Company example on pages 136140 and to Exhibit 4-7. The following list gives various resources used by Lopez Plastics Company. Use the letters D, I and U to indicate how...
-
Suppose you are the controller of Nebraska State University. The university president, Lisa Larsson, is preparing for her annual fund-raising campaign for 20X720X8. To set an appropriate target, she...
-
You have estimated the value per share for Littlefield Inc., a transportation company, under three scenarios: \($5/share\) under the worst case scenario, \($30/share\) under the best-case scenario,...
-
Healthy Foods is a company that produces canned soups made without preservatives. The firm has assets that have a book value of $100 million. The assets are five years old and have been depreciated...
-
You are analyzing Delta Enterprises, a small publicly traded company with \($50\) million of debt outstanding, and 25 million shares, trading at \($10/share.\) The firm generated \($40\) million in...
Study smarter with the SolutionInn App