Fill the boxes Consider the following financial information and budgeted projections for Globe Inn. 1.) Projected sales
Fantastic news! We've Found the answer you've been seeking!
Question:
Fill the boxes
Transcribed Image Text:
Consider the following financial information and budgeted projections for Globe Inn. 1.) Projected sales revenue and related collections information: November 2020. December 2020 January 2021 February 2021 March 2021 $ 30,000 $ 45,000 $ 50,000 $ 88,000 $ 67,000 Historically, 35% of all monthly sales are cash sales. For sales that are not collected immediately, 45% of monthly sales are collected in the month following the sale (after 30 days), and 20% of monthly sales are collected in the second month after the sale (after 60 days). 2.) Total monthly merchandise purchase costs average 40% of total sales revenue for that month. According to management policy, 40% of these monthly purchases are cash purchases and therefore paid in the same month as the purchase. The remaining 60% of the monthly purchases were credit purchases on account and are paid in the month following the purchase (after 30 days). 3.) Employee wages are paid in cash at the end of each month, and on average total wages paid is equal to 15% of total sales revenue for that month. Interest on mortgage [see (a)] Depreciation Property taxes [see (b)] Insurance [see (c)] Other expenses [see (d)] 4.) Other budgeted expenses are as follows: December January February March $ 1,520 $1,500 $ 1,495 $ 1,490 2,000 2,000 2,000 500 500 500 500 2,000 2,000 2,000 500 500 500 500 2,000 2,000 Additional information relating to these budgeted expenses is as follows: (a) The interest presented above represents a portion of Globe Inn's $2,000 total monthly cash mortgage payment, the remaining portion represents a the payment to reduce the loan principle. (b) The budgeted property taxes expense represents the allocated 'accounting' expense portion of the total annual cost that is reported equally to each month. However, the municipality requires that property taxes be paid in $3,000 installments twice per year, once in January, once in July. (c) The budgeted insurance expense represents the allocated 'accounting' expense portion of the total annual premium that is reported equally to each month covered by the policy. However, the insurance premiums are paid in installments of $1000 every other month beginning in December. (d) Other expenses are paid each month as the expense is incurred. Consider the following financial information and budgeted projections for Globe Inn. 1.) Projected sales revenue and related collections information: November 2020. December 2020 January 2021 February 2021 March 2021 $ 30,000 $ 45,000 $ 50,000 $ 88,000 $ 67,000 Historically, 35% of all monthly sales are cash sales. For sales that are not collected immediately, 45% of monthly sales are collected in the month following the sale (after 30 days), and 20% of monthly sales are collected in the second month after the sale (after 60 days). 2.) Total monthly merchandise purchase costs average 40% of total sales revenue for that month. According to management policy, 40% of these monthly purchases are cash purchases and therefore paid in the same month as the purchase. The remaining 60% of the monthly purchases were credit purchases on account and are paid in the month following the purchase (after 30 days). 3.) Employee wages are paid in cash at the end of each month, and on average total wages paid is equal to 15% of total sales revenue for that month. Interest on mortgage [see (a)] Depreciation Property taxes [see (b)] Insurance [see (c)] Other expenses [see (d)] 4.) Other budgeted expenses are as follows: December January February March $ 1,520 $1,500 $ 1,495 $ 1,490 2,000 2,000 2,000 500 500 500 500 2,000 2,000 2,000 500 500 500 500 2,000 2,000 Additional information relating to these budgeted expenses is as follows: (a) The interest presented above represents a portion of Globe Inn's $2,000 total monthly cash mortgage payment, the remaining portion represents a the payment to reduce the loan principle. (b) The budgeted property taxes expense represents the allocated 'accounting' expense portion of the total annual cost that is reported equally to each month. However, the municipality requires that property taxes be paid in $3,000 installments twice per year, once in January, once in July. (c) The budgeted insurance expense represents the allocated 'accounting' expense portion of the total annual premium that is reported equally to each month covered by the policy. However, the insurance premiums are paid in installments of $1000 every other month beginning in December. (d) Other expenses are paid each month as the expense is incurred.
Expert Answer:
Related Book For
Advanced Accounting
ISBN: 978-1259444951
13th edition
Authors: Joe Ben Hoyle, Thomas Schaefer, Timothy Doupni
Posted Date:
Students also viewed these accounting questions
-
What amount of foreign exchange gain or loss should be reflected in McCarthy's 2017 consolidated net income? a. $8,000 loss. b. $10,000 loss. c. $2,000 gain. d. $5,000 gain. McCarthy, Inc.'s...
-
What is the amount of service department cost allocated to P1 and P2 using the step method with S1 goingfirst? Percentage Service Provided to: Department Cost S1 S2 P1 P2 Service 1 (S1] Service 2...
-
What is the amount of the standard real estate commission charged by brokerage firms in your community? Assume you own a home in which your equity is $25,000, and that you are about to sell for...
-
In Exercises find the extrema and the points of inflection (if any exist) of the function. Use a graphing utility to graph the function and confirm your results. f(x) = xe-x
-
Using the regression equation calculated in Question 5, create plots of the residuals versus each explanatory variable in the model. Also create a plot of the residuals versus the predicted retail...
-
Explain why endogeneity is a potential problem in random effects models, and how it affects our choice of estimator.
-
Simons Realty issued \(\$ 250,000\) of \(6 \%, 10\)-year bonds payable at par value on May 1,2006, four months after the bond's original issue date of January 1, 2006. Journalize the following...
-
(a) Rochelle Company ships merchandise to Jay Company on December 30. The merchandise reaches the buyer on January 6. Indicate the terms of sale that will result in the goods being included in (1)...
-
||! Menu | Fresh C X Q CANVAS UT AU X Assignment 4 X PDF Assignment 4 = Gov337G Notes X Inbox (5,361) Campus ConneX File C:/Users/dolly/Downloads/Assignment%204%20on%20BC.pdf Draw T Read aloud + 1 of...
-
The Metropolitan Transit Authority (MTA) has just opened a new subway line (the Orange Line) in its underground transportation network. The Orange Line had a capital investment of $20 million,...
-
Frank Inc. is trying to decide whether to lease or purchase a piece of equipment needed for the next ten years. The equipment would cost $45,000 to purchase, and maintenance costs would be $5,000 per...
-
1. Go to PowerofAttorney.com ( https://powerofattorney.com/medical-power-attorney/ ) to access a free printable medical (healthcare) power of attorney form from your state and another state. Compare...
-
1. What is a microstate? 2. How you do determine how many microstates a system may have? 3. What does Boltzmann say about entropy?
-
Snap Company issued $200,000 of 8%, 5-year bonds on January 1, 2020. The discount on issuance was $12,000. Bond interest is paid annually on December 31. On December 31, 2022, Pele Company purchased...
-
7. Examine the continuity of the following functions (a) f(x) = (3x-2, x <2 at x = 2. x+2,x2 (b) f(x) = x ,x=0 at x=0. 2, x = 0.
-
(a) What impulse must be imparted to a golf ball of mass 0.044kg to give it a velocity of 52.2m/s? (b) If the golf club is in contact with the ball as it is accelerated over an interval of 1.01cm,...
-
How did XYZ Company sustain the effectiveness of their inventory management and control system over time?
-
Suppose that you could invest in the following projects but have only $30,000 to invest. How would you make your decision and which projects would you invest in? Project Cost $ 8,000 11,000 9,000...
-
What assets are viewed as current financial resources?
-
What federal legislation governs most bankruptcy proceedings?
-
Which of the following is true about use of the modified approach? a. It can be applied to all capital assets of a state or local government. b. It is used to adjust depreciation expense either up or...
-
The pendulum has a mass of \(7.5 \mathrm{~kg}\) with center of mass at \(G\) and has a radius of gyration about the pivot \(O\) of \(295 \mathrm{~mm}\). If the pendulum is released from rest at...
-
A metal hoop with a radius \(r=6\) in. is released from rest on the \(20^{\circ}\) incline. If the coefficients of static and kinetic friction are \(\mu_{s}=0.15\) and \(\mu_{k}=0.12\), determine the...
-
The \(\operatorname{drum} A\) is given a constant angular acceleration \(\alpha_{0}\) of \(3 \mathrm{rad} / \mathrm{s}^{2}\) and causes the 70-kg spool \(B\) to roll on the horizontal surface by...
Study smarter with the SolutionInn App