Reference no: EM131073052
Georgette P. Burdell, acting as GPB Inc., weaves cotton place mats to sell through a local craft shop. Because this is a hobby, Georgette does not consider labor time/costs in her financials. The mats sell at a market price for $20 per set of four. The local craft shop charges a 10% commission and remits the net proceeds to GPB Inc., at the end of December. Georgette has woven and sold 25 sets each year for the past two years and expects to sell 26 sets this year. She has enough cotton in inventory to make 26 sets. She paid $7 per set for the cotton. Georgette uses a four-harness loom that she purchased for cash exactly two years ago. The loom is depreciated at the rate of $10 per month. The Accounts Payable balance relates to the cotton inventory and is payable by September 30.
Georgette is considering buying an eight-harness loom so that she can weave more intricate patterns in linen. The new loom costs $1,000 and would be depreciated at $20 per month. Her bank has agreed to lend her $1,000 at 24% interest per year, with $200 payment of principal, plus accrued interest payable each December 31.
Georgette believes she can weave 16 linen place mat sets in time for the Christmas rush if she does not weave any cotton mats. She predicts that each linen set will sell for $50. Linen costs $18 per set. Georgette's supplier will sell her linen on credit, payable December 31.
Georgette plans to keep her old loom whether or not she buys the new loom. The balance sheet for her weaving business at August 31, 2016, is as follows:
GPB Inc. Balance Sheet 31-Aug-16
|
Assets
|
Actual
|
Current Assets
|
$$$
|
Cash
|
$118
|
Inventory
|
182
|
Total Current Assets
|
300
|
Property, Plant, & Equipment
|
|
Loom
|
500
|
less: Accumulated Depreciation
|
-240
|
Total PP&E
|
260
|
Total Assets
|
$560
|
Liabilities
|
|
Current Liabilities
|
|
Accounts Payable
|
$74
|
Notes Payable
|
0
|
Total Current Liabilities
|
74
|
Stockholders' Equity
|
|
Retained Earnings
|
486
|
Total Liabilities and Stockholders' Equity
|
$560
|
Required
1. Build, from a blank file, a spreadsheet in Microsoft Excel or Google Sheets, which will enable you to prepare the budgeted statements listed under requirement #2 below. The cash budgets must be "linked", using cell references, etc., to the required financial statements and to your assumption figures. To maximize points awarded, use an 'assumption table.'
2. Prepare GPB Inc.s' cash budget for 'the four months ending on December 31, 2016' for the two alternatives: #1) weaving the place mats in cotton using the existing loom and #2) weaving the place mats in linen using the new loom. For each alternative, prepare a budgeted income statement for `the four months ending December 31, 2016', and a budgeted balance sheet at December 31, 2016. [NOTE: For each alternative this is one cash budget that covers four months and not four one-month cash budgets. Same applies to the budgeted income statement.]
3. On the basis of financial considerations only, what alternative should GPB Inc. consider doing? What non-financial factors might Georgette consider in her decision?
Northeastern insurance company
: Northeastern Insurance Company is considering opening an office in the U.S. The two cities under considerations are Philadelphia and New York. The factor ratings (higher scores are better) for the two cities are given in the following table.
|
Differences between international and domestic terrorism
: Explain the differences between international and domestic terrorism. Which type of terrorism currently poses a larger threat to the United States? Why?
|
What are two major types of qualified pension
: What are two major types of qualified pension? What are the policy reasons for the advantages of qualified retirement plans?
|
Described how the program might be evaluated
: Summarized a theory of juvenile delinquency, discussed how it specifically addresses the selected target issue, and critically evaluated the theory and demonstrated how its concepts apply to the program.
|
Prepare gpb incs cash budget for the four months ending
: Prepare GPB Inc.s' cash budget for 'the four months ending on December 31, 2016' for the two alternatives: #1) weaving the place mats in cotton using the existing loom and #2) weaving the place mats in linen using the new loom.
|
What issues you will look
: Your letter/diary should explain what happened, what issues you will look into and some ideas about how you will deal with the situation. If the scenario you have chosen is touched on in your textbook you can mention what you are leaning in the cl..
|
Discuss the impact that these attributes exert on citizens
: From the first e-Activity, identify at least three (3) specific attributes that lead to gang violence within a community. Discuss the impact that these attributes exert on citizens. 150 word min.
|
Join these points with a straight line; this is the ppf
: Join these points with a straight line; this is the PPF.
|
How does emotion affect motivation
: Describe thinking, intelligence, and creativity. How are thinking, intelligence, and creativity related? Does one's creativity illustrate anything about his or her thinking processes or level of intelligence? Why or why not? Your response must be ..
|